Forum Discussion
Formula between 2 columns
Happy Weekend Quick question. I have the USD column per month and I created a colum called "Risk". Now I want to create a formula Risk% = (DIVIDE('Weekly Slippage'[Risk], 'Weekly Slippage'[U...
HI
Instead of Weekly Slippage USD...i created a measure called FY23 to calculate only the USD during Fiscal year.
FY23 Starts = CALCULATE(SUM('Weekly Slippage'[USD]), DATESBETWEEN('Weekly Slippage'[Ops Forecast & Actuals], DATE(2022,7,1), DATE (2023,06,01)))
I am trying to add the same "FY23 filter" to the below Risk formula but i need help.
Risk = CALCULATE(SUM('Weekly Slippage'[USD]),DATESBETWEEN('Weekly Slippage'[Ops Forecast & Actuals], DATE(2022,7,1), DATE (2023,06,01), FILTER ('Weekly Slippage', 'Weekly Slippage'[Project Health] IN {"Red" ,"Orange"}))
Thanks