Forum Discussion

runnerpaul's avatar
runnerpaul
Regular Visitor
10 years ago

Use different filter calculations depending on comapny

Hi,   I have the below DAX which returns a budget calc for the current period   BudgetCalcForPeriod:=CALCULATE(SUM(Budget[Budget]), FILTER(Budget, Budget[YearPeriod] = MAX(BI_SalesAnalysis[YearPe...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

I'd have to see the original data to be sure, but it should theorectically be possible by using IF.