I am trying to filter for a product in my DAX calculation for a running total. In the Budget table, I have a column for BudgetSort. I need to add something like IF BudgetSort = 5 to the calculation. I have been struggling for two days on this.
Running Budget RBC =
VAR LastBillingDate = CALCULATE( LASTDATE(Budget[Dates.Date]),ALL( Budget))
IF(‘Budget Measures’[Total Budget] <> BLANK () ,
Budget[Dates.Date] <= LastBillingDate