Issue in Creating Calendar till Previous month end Date.

[atul9063]

Hi,

I m using below DAX 

Calender = CALENDAR("7/1/2018",EDATE(EOMONTH(TODAY(),0),-1)) to generate dates from "7/1/2018" to "10/31/2018"

But i m getting dates till 10/20/2018. Let me know how to create calender  till Previous month last date.

[affan · Accepted solution]

Hi @atul9063

Please use the below DAX

Calender = CALENDAR("7/1/2018",EDATE(EOMONTH(TODAY(),-1),0))

If this helped you, please mark this post as an accepted solution and like to give KUDOS .

Regards,

Affan