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.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
9 months ago
 Because I have a customer date table, I can't use the time intelligence functions.

We have a similar issue. The best way to handle this is via OFFSET(-1) on the Year column of your calendar table.