Days Elapsed in Current Month

[Anonymous]

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

[Tahreem24 · Accepted solution]

@Anonymous , Try this DAX

Solution 1 = DATEDIFF(DATE(2022,11,1),TODAY(),DAY)

OR
Solution 2 = DATEDIFF(Table[DateColumn],TODAY(),DAY)

[PaulDBrown · Accepted solution]

Try:

Days elapsed current month =
DATEDIFF(EOMONTH(TODAY(), -1) +1, TODAY(), DAY)

[Anonymous]

@Tahreem24 @PaulDBrown 
Thanks a lot for the solution.

[Tahreem24 · Accepted solution]

@Anonymous Try this also,

DateDiff = DATEDIFF(STARTOFMONTH('Table'[Date]),TODAY(),DAY)

[PaulDBrown · Accepted solution]

Try:

Days elapsed current month =
DATEDIFF(EOMONTH(TODAY(), -1) +1, TODAY(), DAY)

[Tahreem24 · Accepted solution]

@Anonymous , Try this DAX

Solution 1 = DATEDIFF(DATE(2022,11,1),TODAY(),DAY)

OR
Solution 2 = DATEDIFF(Table[DateColumn],TODAY(),DAY)