Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |