Forum Discussion

Yin34's avatar
Yin34
Frequent Visitor
4 years ago

Dynamically Pick Min Date based on slicer's selection

Hi friends,  I am still new to Power BI, hope you guys can provide me some guidance. Here is my situation: I would like to pick min date for each level of percentile (low, mid, and high) from each ...
Dynamic Column
MIN date
Slicer based on calculated Measure
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

Yin34 Correct, calculated columns are not dynamic based upon user input. You would need a measure like:

LowDate = 
  VAR __LowPCT = [LowPCT]
RETURN
  CALCULATE(MIN('Table'[SlotDatetimeDTS]),FILTER(ALL('Table'),'Table'[PctAvailable]>__LowPCT))
  • Yin34's avatar
    Yin34
    Frequent Visitor
    4 years ago

    Hi Greg Greg_Deckler 

    Thanks for the reply!

    For the measure you proposed, is there a way to add the condition for ProviderID? Because I would like to pick the min date for each provider separately. Like in the screenshot, the LowDate for provider 403 is 10/13, but the min date for other providers could be different if his/her min SlotDateTimeDTS with PctAvailable >10% is not 10/13. It looks like your formula pick the overall min date across all the providers. 

     

    Thank you so much!