Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Setting variable dates as filters

**Problem resolved but post can't be deleted**   I'm having an issue with filtering values using variable dates. Currently my formula is as follows:   Measure= VAR MinYear = CALCULATE(MIN(Raw...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    I've actually managed to fix this!

    Turns out I had a filter being applied via another slicer which was changing the date ranges and therefore not applying the assumed window.

     

    Thanks anyway all!

v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi Anonymous ,

 

Is this what you want?

COUNT(RawData[Ref])
  when RawData[date] >= MinYear && RawData[date] <= MaxYears

Could you show me a sample data model? I need to know the relationship between 'RawData' table and 'Years' table.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.