Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Date filtering

Existing table contain a measure as "month of processing" data type: Text   2019-Jan 2018-Dec 2019-May 2019-Feb Etc.....   In my reports im going to use this measure - "month of processing" ...
Need Help
Show and Tell
Tips and Tricks
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    How does this measure calculate?

    If it comes from a date column as below

    month of processing = FORMAT(MAX(Sheet3[date]),"yyyy-mmm")

    It is sorted incorrectly in a table or matrix visual, is this your scenario?

    If so, you could modify the measure as below so that it can be sorted correctly.

    Measure = FORMAT(MAX(Sheet3[date]),"yyyy-mm")

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous 

How does this measure calculate?

If it comes from a date column as below

month of processing = FORMAT(MAX(Sheet3[date]),"yyyy-mmm")

It is sorted incorrectly in a table or matrix visual, is this your scenario?

If so, you could modify the measure as below so that it can be sorted correctly.

Measure = FORMAT(MAX(Sheet3[date]),"yyyy-mm")

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.