Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi,
I have a date slicer which filters the data based on two dates.
I wanted to get the upper value selected in the slicer but I've not been able to get it.
I tried this formula, picking it from previous messages on Power BI Community but it doesn't work:
CALCULATE ( MAX ( MyDateTable[Date] ), ALLSELECTED ( MyDateTable[Date] ) )
Can you help me?
Thanks!
Hi @AMS_Pag ,
Have you tried using Relative date slicer in this scenario? There is similar thread for this:
https://community.powerbi.com/t5/Desktop/Default-upper-value-for-date-slicer/m-p/876220
Kindly give kudos if this is helpful or aceept this as a solution if it works! 🙂
Thanks,
Pragati
Yes, I tried it, but also after setting the relative filtering I can't get the "upper" date.
I need to get the upper date dynamically, as it is changed (e.g. if the upper date is changed I need to get the new value, obviously). 😋
Unfortunately this DAX returns a compilation error... 😞
Do you have other suggestions?