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
sabd80I tried this but it did not work