Forum Discussion
Time comparison multiple years
Hello everyone, I’ve been struggling the past few days with DAX-formulas to compare several years. On the internet there are several formulas but none of them gives me the result I want. What’s th...
Hi Anonymous
The function you neccesary need is SAMEPERIODLASTYEAR, or even better DATEADD.
With this function you can calculate multiple measures just changing intervals numbers.
About how clasiffy your clients, based on sales. You have to create a manual table, and then you can use Switch function to clasify each row or customer or whatever....
EnterpriseDNA has tutorials in youtube, but I cannot find it right now.
I've found this one from Curbal, which may help you with Virtual Tables and Summarize Function.
https://www.youtube.com/watch?v=-Ola264bKXk
Good luck!:smileyvery-happy: