Forum Discussion

sammy02hk's avatar
sammy02hk
Icon for Helper I rankHelper I
3 years ago

Retrieve the Max date from slicer

Hi there,   I would like to retrieve the Max date from slicer. What I want is test fix @06/12/2022, rather than 06/11/2022 for site 1001 test = CALCULATE(MAX(DATA_LIST_CUR_DateMatch[Date]),ALLSE...
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago

not really get your point.

but, if these is not data at Jun 12 for site 1001 in your fact table, your measure will never get the value of Jun 12.

  • sammy02hk's avatar
    sammy02hk
    Icon for Helper I rankHelper I
    3 years ago

    wdx223_Daniel 
    I am trying to fix the var value @12/6/22 rather than 11/6/22 bypass the fact data.