Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi all,
I would like to create a measure that creates the difference between a column and the first value of that column so I can display deltas between the first value (reference value) and the rest of the values. For example, in Excel this would simply be:
where row 1 is bolded and serves as the reference value.
I see that there is a "Variance" quick measure but that just shows the difference from row to row, not to a single reference value. I have tried this approach but it produces all 0's when I add it as a column to my table:
User | Count |
---|---|
21 | |
14 | |
11 | |
7 | |
5 |
User | Count |
---|---|
23 | |
23 | |
20 | |
15 | |
10 |