Forum Discussion
Solved
Group by date into month
From table A date organization_id merchant_id price number_of_bookings 01/01/18 A 1001 50 3 02/01/18 A 1001 ...
Hi,
I suggest proceed the aggregation steps in Power Query Editor.
The sample pbix file's link is down below.
The link to the sample pbix file
Jihwan_Kim
Super User
Super UserHi,
I suggest proceed the aggregation steps in Power Query Editor.
The sample pbix file's link is down below.
The link to the sample pbix file
managed to replicate the steps, thank you.
Just one question, grouping by month and by year separately, will that cause a problem?
Should I merge month and year first before doing a group by?