Forum Discussion
Days Elapsed in Current Month
Hello Power BI Enthusiast, I want to get how many days elapsed in the current month. For example: Today is 8th November So, Output should be 7. Kindly help. Regards, AJP
Anonymous , Try this DAX
Solution 1 = DATEDIFF(DATE(2022,11,1),TODAY(),DAY)OR
Solution 2 = DATEDIFF(Table[DateColumn],TODAY(),DAY)Try:
Days elapsed current month = DATEDIFF(EOMONTH(TODAY(), -1) +1, TODAY(), DAY)Anonymous Try this also,
DateDiff = DATEDIFF(STARTOFMONTH('Table'[Date]),TODAY(),DAY)
Tahreem24 PaulDBrown
Thanks a lot for the solution.