Forum Discussion
sabd80
Helper IV
Helper IVDAX 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...
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.
Ritaf1983
Super User
Super UserHi sabd80
Please relate to the linked goodly's guide:
https://www.youtube.com/watch?v=iqUTHlfHomg
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
sabd80Helper IV
Helper IVI tried this but it did not work