Forum Discussion
Solved
Ignore values less than zero in calculation
Hi I just started with Power-BI and I am struggeling with something I could solve in Excel in notime -.- I have a colum (Act_ATSys_OI) where the weekly bookings get calculated from another table...
Hi D_Eichenberger,
Based on my test, you can refer to below steps:
You can create a column to calculate your value and you can see the result.
Total running = IF([Act_ATSys_OI]<>0,CALCULATE(SUM(Sheet1[Act_ATSys_OI]),
FILTER(ALL(Sheet1),'Sheet1'[Act_week]<=EARLIER(Sheet1[Act_week]))))
You can also download the PBIX file to have a view.
Regards,
Daniel He
Hi D_Eichenberger,
Based on my test, you can refer to below steps:
You can create a column to calculate your value and you can see the result.
Total running = IF([Act_ATSys_OI]<>0,CALCULATE(SUM(Sheet1[Act_ATSys_OI]),
FILTER(ALL(Sheet1),'Sheet1'[Act_week]<=EARLIER(Sheet1[Act_week]))))
You can also download the PBIX file to have a view.
Regards,
Daniel He
You made my day! Thanks a lot, works like a charm.