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.
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
AdministratorThat'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.