Forum Discussion

Regular Visitor

3 years ago

Solved

undefined

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

Need Help

Show and Tell

Ashish_Mathur
3 years ago
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.

Ashish_Mathur

Super User

3 years ago

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

Regular Visitor

3 years ago

Thank you, I will try this solution! 🙂