Date filtering

[Anonymous]

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" so

i facing problem with make this in order  

can anyone help me on this 

thanks 

[v-juanli-msft · Accepted solution]

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.