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 everyone!
I'm having some problem, with writing formula.
I have this in matrix:
Where Company and Week/Year are Columns, that cant be pivoted, and Value is some Measure:
BIAS_W_12 = IFERROR((SUM('DPA BIAS'[Final CDP W-12])-SUM('DPA BIAS'[Order Quantity]))/SUM('DPA BIAS'[Final CDP W-12])*100;0)
I want to make a Column for every of this weeks where i will have a value of a measure, when week is ok, 0 otherwise.
Can you help me how to do it?
I'm stuck for a few hours now.
Thank You
Radkos
Solved! Go to Solution.
@Anonymous,
You may try the following pattern.
Measure = VAR w = SELECTEDVALUE ( Table1[Week/Year] ) RETURN IF ( w = 12, 1, 0 )
@Anonymous,
You may try the following pattern.
Measure = VAR w = SELECTEDVALUE ( Table1[Week/Year] ) RETURN IF ( w = 12, 1, 0 )
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |