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'm looking for help to solve this calculation.
I have two columns of sales: This Year & Last Year.
I want to calculate expected sales if I serve the same customers as last year.
Example:
Total sales this year is 240 based on two customers (A + B). We still need to serve the last customer (C). If customer C buys for same amount as Last Year (100) we will expect our total sales to be 120+120+100 = 340
Customer | This year | Last year |
A | 120 | 100 |
B | 120 | 100 |
C | 100 | |
Total | 240 | 300 |
How does the calculation look like?
Best regards
Mathias
@mnb_dk , a new meausre
Sumx(Values(Table[Customer]), if(isblank([This Year]), [Last Year], [This Year]))
Hi Amit
Thanks for replying.
Unfortunately this didn't return the correct value.
It retuns the total value from Last Year.
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 |
---|---|
106 | |
98 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |