Forum Discussion

ozne99's avatar
ozne99
Frequent Visitor
6 years ago
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...
Need Help
  • ozne99's avatar
    ozne99
    6 years ago

    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)

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

"what is selected in the slicer"  - this immediately disqualifies the request as you cannot create columns from measures.

 

Have a look at the FILTERS() or VALUES() functions if you want to do this with measures.

ozne99's avatar
ozne99
Frequent Visitor
6 years ago

Thanks the tip; I've tried to use various combinations of VALUES() and FILTERS() early on, but not sure how to incorporate it into my need.

 

Ultimately, I want the column to flag dates less than the slicer selection, but not sure how to build that out.