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,
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
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 |
---|---|
105 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
141 | |
107 | |
100 | |
82 | |
74 |