Forum Discussion

sabd80's avatar
sabd80
Icon for Helper IV rankHelper IV
9 months ago
Solved

DAX Last Year based on custom date dimension

Hi, I have a customer date table for finacnial date, I want to calculate the measures for last year. Because I have a customer date table, I can't use the time intelligence functions. I would lik...
Need Help
  • v-ssriganesh's avatar
    v-ssriganesh
    9 months ago

    Hi sabd80,
    Thank you for reaching out to the Microsoft fabric community forum. I reproduced the scenario, and it worked on my end. I used my sample data and successfully implemented it.


    I am also including .pbix file for your better understanding, please have a look into it:

    Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.

    Thank you for using the Microsoft Fabric Community Forum.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
9 months ago

sabd80 , Even if the customer date table, as long as it has all dates/continuous dates it will work. Unless the calendar is not standard.

We got a new calendar option recently that you can use again if you have a continuous date
https://powerbi.microsoft.com/en-us/blog/calendar-based-time-intelligence-time-intelligence-tailored-preview/

Using offset, window can be another option as suggested by lbendlin 
Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc
Power BI Offset Compare Categories, Time Intelligence MOM, QOQ, and YOY: https://youtu.be/5YMlkDNGr0U

If can create new columns, then Rank can help 
Power BI Custom Period Till Date (PTD)- https://youtu.be/rQ3Z_LtxwQM


sabd80's avatar
sabd80
Icon for Helper IV rankHelper IV
9 months ago

The calendar is not standard.