Check selected date range is month or year or week or day

[remo143]

Hi,

I have a relative date slicer in my report that allows user to select different date value(Last, Next or This month, year, week, I have diff measures for different date ranges like: For week, one measure, for month, one measure, for quarter, one measure and for year, one measure and for daily, one measure.

I need to dynamically associate one of above measures based on user selection. Say, if user selects Last 1 week, then weekly measure, if user selects 1 month, then monthly measure etc.

Please help me how to know user selection and associate the respective measure in Dax.

[v-chuncz-msft]

@remo143,

As far as I know, there is no DAX function available. You may use MIN Function and MAX Function to get the range.