Forum Discussion
jackypatel
Helper I
Helper INeed Last Month Data in My Card View
I have a calender that contain April is the starung Month & March is the Last Month of the year. For Example i have data like Month & Return as mention below Month Return Apr-23 53690 ...
Tutu_in_YYC
Super User
Super UserBefore you try to get the last month calculation, you will need a fiscal date, bbecause your start date is not jan.
Have a look at how to set one up.
https://pragmaticworks.com/blog/dynamic-fiscal-year-date-table-using-dax-in-power-bi.
Then for the last month measure, you can just create a calculation using time intelligence or some manipulation of filter context.
Share a pbix if you can.
jackypatelHelper I
Helper Ii am unable to attached the File. Data is already There.
Plz help