Forum Discussion
Sort with DAX Function FORMAT
Hello All. Does anyone know when the bug will be fixed for sorting measure values that have the FORMAT() function applied to them?
In case you have created a measure like
Month year = format(Date[date],"MMM-YYYY") which is text and not take date sorting anymore
create a measure like
Month year Sort= format(Date[date],"YYYYMM") and mark it as sort column