Date features

[Anonymous]

months = DATESBETWEEN(Dim_Reported_Calendarday[DAY];Dim_Incident_Calendarday[First Day of This Month];[currentdate])

is this incorrect for finding days between first day of month and sysdate

can you similarly help for

1. first day of year and current date

2.first day of week and current date

[Seward12533 · Accepted solution]

Try DATEDIFF https://msdn.microsoft.com/en-us/query-bi/dax/datediff-function-dax

Current date is either NOW() date-time when workbook opened or TODAY() current date-time 

First day of Week - https://community.powerbi.com/t5/Desktop/Week-commencing-in-DAX/td-p/241304

First day of year =DATE(YEAR(TODAY(),1,1) 

First day of month = DATE(YEAR(TODAY),MONTH(TODAY(),1)

Days Since First Day of Month = TODAY()-DATE(YEAR(TODAY),MONTH(TODAY(),1)

-or-

Days Since First Day of the Month = DATEDIFF(DATE(YEAR(TODAY),MONTH(TODAY(),1),Today(),DAYS)

The second option is more general and can be used to count hours, days, weeks, quarters or whatever