Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello ,
my data represented by two columns , Quantity and date .
I have created a measure to calculate the Variation coefficent as below :
this calculates it based on daily hierarchy as below :
my aim is to have it calculated the variation % based on weekly , monthly and yearly as well .
I need 3 more measures that calculates variation % from week to week , month to month and year to year .
how can i write this in DAX ?
Thanks .
Hello , any other help from the community ?
@Ahmad_K , You can use time intelligence to get such measures
Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s
Thanks but I didn't get it for my case . please just elaborate with one example , let it be month to month variation % .