Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have two measures with one data point in each and I want to calculate the %-difference between these in a card, how can I do that correctly?
The formulas for the measures are as follows:
So I would want a card saying "-25%" in this case (ie (6-8)/8=-0,25)
I also wonder how I can change the format of the date in the chart? It does not format as in the source table.
Solved! Go to Solution.
@Anonymous
One if the two
Difference % = divide([Quantity Last Period] - [Current Quantity]) , [Current Quantity])
Difference % = divide([Quantity Last Period] , [Current Quantity]) -1
Hi @Anonymous ,
Check if the reply above solved you first question. And for you second question, you can select the column then find the Format feature under Modeling pane.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous
One if the two
Difference % = divide([Quantity Last Period] - [Current Quantity]) , [Current Quantity])
Difference % = divide([Quantity Last Period] , [Current Quantity]) -1
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |