Getting date value from report date filter

[gvg]

Hi All,

Is it possible to get filter level value in the report? I need to perform different calculations based on which date hierarchy level is selected. I.e. if years are selected, I need to apply one formula, if months are selected, the formula is different, etc.. Is there a way to know if user has filtered the report by year, quarter, month or day? Like in this example below I need to know what is the lowest date hierarchy filtered. In this case it is Quarter.

[v-chuncz-msft]

@gvg,

You may use ISFILTERED Function in a measure.