Forum Discussion
Power BI Dates Grouping Individually
That's why TDFecha is useful, you create a month number column and use the sort by Column tool, sorting YEAR_MONTH by Month(In number).
Recommendation, since you have several values in a month for the same value in YEAR_MONTH, what I do is filter specific days from Power Query, so that there is a 1 - 1 relationship, like the following example.Then you sort it by...
In case it gives you an error, save your changes, close the file, and try again.
If this publication help , considering accept it as the solution to help other members find it more quickly.
Why not work with a calendar dimension table and make your modifications to this table according to your need?
Give it a try and comment on how it went.
That "works" in the sense that they do group together. But the column is not longer in Date format, once you use the FORMAT function it turns it into TEXT. And then it doesn't sort in order so kind of defeats the whole purpose
That's why TDFecha is useful, you create a month number column and use the sort by Column tool, sorting YEAR_MONTH by Month(In number).
Recommendation, since you have several values in a month for the same value in YEAR_MONTH, what I do is filter specific days from Power Query, so that there is a 1 - 1 relationship, like the following example.Then you sort it by...
In case it gives you an error, save your changes, close the file, and try again.
If this publication help , considering accept it as the solution to help other members find it more quickly.