undefined

[sgdb]

Hi, I wanted to group this days with multiple values in one same date, when I look for solutions is says I can group via Power query, but after doing this I lost all my report as the data was changed.

The question is can I group this dates into one day of each calendar month?

I would really appreciate your help.

thanks

Sandra

[Ashish_Mathur · Accepted solution]

Hi,

You should create a Calendar Table with a relationship (Many to One and Single) from the Date column of the Data Table to the Date column of the Calendar Table.  In the Calendar Table, create calculated columns of Year, Month name and Month number.  Sort the Month name column by the Month number column.  To your visual, drag Year and Month name from the Calendar Table.

[sgdb]

Thank you, I will try this solution! 🙂