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)
4 Replies
PaulDBrownCommunity Champion
Try:
Days elapsed current month = DATEDIFF(EOMONTH(TODAY(), -1) +1, TODAY(), DAY)
Tahreem24Super User
Anonymous , Try this DAX
Solution 1 = DATEDIFF(DATE(2022,11,1),TODAY(),DAY)OR
Solution 2 = DATEDIFF(Table[DateColumn],TODAY(),DAY)- Tahreem24
Anonymous Try this also,
DateDiff = DATEDIFF(STARTOFMONTH('Table'[Date]),TODAY(),DAY) Tahreem24 PaulDBrown
Thanks a lot for the solution.