Forum Discussion
sammy02hk
Helper I
Helper IRetrieve 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]),ALLSELECTED(DATA_LIST_CUR_DateMatch[Date]))
Thank you for your help.
Cheers,
Sammy Chu
3 Replies
- wdx223_Daniel
Community Champion
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.
sammy02hkwdx223_Daniel
I am trying to fix the var value @12/6/22 rather than 11/6/22 bypass the fact data.
andhiii079845Solution Sage
Same problem ike wdx223_Daniel . One way can be to us a separate dimTable and us the date from this table as a slicer.
