Forum Discussion
Solved
Sort by Date X - Axis
Hi, I am connecting to a SQL server instance. I have a date/time field called DateInspected. I want to use this field but want to convert this date field to mm-yyyy and use this in a bar chart and ...
Hi SachinC ,
Syntax I gave you is for a DAX column you should replace the dot comma by comma (it's regional setting thing).
FORMAT([DateInspected],"mm-yyyy")On the query editor the formula should be:
Text.Combine({Date.ToText([DateInspected], "MM"), "-", Date.ToText([DateInspected], "yyyy")})
Try replacing the semi-colons in MFelix 's solution with commas. It varies based on language version of Power BI Desktop.
Using commas didn't work; this is what doesn't work:
DateInspection-M-Y = FORMAT([DateInspected],"mm-yyyy")