Forum Discussion
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" so
i facing problem with make this in order
can anyone help me on this
thanks
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
MaggieCommunity 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.
1 Reply
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
MaggieCommunity 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.