Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team ,
I need to calculate differences and percentage for last quarter value column - previous quarter value column and percentage ((last quarter column-previous quarter column)/last quaretercolumn) in same column using DAX in Power bi
note: There is no dates column only having years and values
Please find the below screens hot for your references
The result should be based on the filter of class and year .I want to year and class as filter slicer to get the differences of last quarter - previous quarter and same in %percentage according to the filter selection .
please find the screen shot of excel sheet image for your references
Thats Column name
Hi @Anonymous
Still not sure which columns are the original data and which are the expected output.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Thanks for reaching out to us.
>> to calculate ((last quarter column-previous quarter column)/last quaretercolumn) based on the filter of class and year, note: There is no dates column only having years and values
how to get the value of last quarter column and the value of previous quarter column? what do these column name in red boxes mean?
and could you share the expected outcome with table format? So that I can verify that my measures are correct according to your expected value. Thanks!
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |