Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Ronie Soriano]

I have a fields with the following:
transaction month: ex. 1,2,3,4,5,6,7…
transaction year: 2019, 2020, 2021….
how to get the total days for example:
month: 1
year: 2019
total days: ???

——————————
Ronie Soriano
——————————

[Mark Wiley]

Hi Ronie,

Do you have a date table? If so (MyDate[Date]):

Days in Month =

CALCULATE(

    COUNTROWS( MyDates ) ,

        ALL( MyDates[Date] ) ,

            VALUES( MyDates[Month Year] ) )

([Month Year] is a column in my date table that has the year and the month in it.
Hope that helps,

——————————
Mark Wiley
Senior Solutions Architect
GraVoc
OH
——————————
——————————————-