Forum Discussion
Power BI
Hey Mates .... I have been trying to build a report where I'm stucked with a issue like month names are not in order ,even after sorting and tried many ways to sort ,by transforming data,adding new ...
Hi sailochanar ,
By using switch function u can create new column and add these new field to the existing filed then apply sorting then it will return.
FYR-
SWITCH(financials[Month Name],"April","04-April","June","06-june")
Thanks & Regards,
Madhan Reddy