Forum Discussion

hassens's avatar
hassens
Regular Visitor
9 years ago
Solved

Highlight Last Visit Within Table Based on Multiple Criteria

Hi,   I'm hoping someone may have tackled a problem similar to mine. I have a table similar in structure to the one below and I want to add a column that dynamically populates with a '1' IF it is t...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    Perhaps a measure like:

     

    Measure = IF([Date]=CALCULATE(MAX([Date]),ALLEXCEPT([Period],[Store])),1,0)
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

Perhaps a measure like:

 

Measure = IF([Date]=CALCULATE(MAX([Date]),ALLEXCEPT([Period],[Store])),1,0)
hassens's avatar
hassens
Regular Visitor
9 years ago

Thanks for this - it worked perfectly!