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.
Solved! Go to Solution.
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,
Check out the News & Announcements to learn more.
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Microsoft received the highest score of any vendor in both the strategy and current offering categories.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.