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 folks,
My data source is given below,
Result required in Power BI
Formula for Yield 2018 is,
IF(AND(Sale 2018<=0,Sale 2019<=0),0,IF(Sale 2018<=0,Sale 2019,0))
I'm not able to get the sum 110 and 50 (Sum of yields) in Power BI.
Please help.
Thank you
Solved! Go to Solution.
@Anonymous
you can try this
Measure = sumx(VALUES('Table'[Customer]),[Yield 2018])
Below is the pbix file for your reference
Proud to be a Super User!
@Anonymous
Please see the attachment.
Proud to be a Super User!
@Anonymous
maybe you can try this workaround,pls see the updated atatchment.
Proud to be a Super User!
Thanx @ryan_mayu
Ur solution is working well when all the numbers are positive.
Can you help me find a solution when number are negative too. I have given a sample data below,
Date | Customer | Sale |
1/1/2018 | A | 10 |
1/1/2018 | B | 20 |
1/1/2018 | C | 30 |
1/1/2019 | C | 40 |
1/1/2019 | D | -50 |
1/1/2019 | E | 60 |
1/1/2019 | B | 50 |
1/1/2020 | C | 40 |
1/2/2020 | F | 30 |
1/3/2020 | G | -20 |
Thank you.
@ryan_mayu
Thank you! It worked...
How can I dynamically change the yield on year selection on slicer?
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 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |