Forum Discussion
Solved
Using Max Date of Separate Table in Column Formula
Hi all, I have a budget dataset with one date column, which I am trying to filter. I have two separate unjoined tables for Date to used to calculate two separate YTD amounts in the budget dat...
Figured it out. Created a SUMX formula to force the calculations to occur at the row level and applied a filter to remove 0 from the visual
Formula: SUMX(BUDGET, IF(AND(BUDGETDATE <= MAX(DATE1), BUDGET DATE >= MAX(DATE2)),1,0)
Figured it out. Created a SUMX formula to force the calculations to occur at the row level and applied a filter to remove 0 from the visual
Formula: SUMX(BUDGET, IF(AND(BUDGETDATE <= MAX(DATE1), BUDGET DATE >= MAX(DATE2)),1,0)