Forum Discussion
Date Format
Hi There, I have a date column called "RDD" with dates e.g. "30.01.2018". Based on that I want to create a new column "RDD Monat" with dates to be in MMM format e.g "Jan". What I did - I c...
Anonymous
You can add a column to correct the sort order. What we need is the month number like so.
Month Sort = MONTH ( 'ORDER - Jumbo Query'[RDD] )Then you select the [RDD Monat] column and set the sort order to the [Month Sort] column. Here is an example from another project on how to set the sort by column:
You are taking ".Month" that is causing that.
You need to use date only
RDD Monat = FORMAT('ORDER - Jumbo Query'[RDD];"MMM")Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601