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
amitchandak
Super User
Super Useralpb , if you want it for file reduction, Split column in power query or use option text before/after the delimiter
And then group by
Else in DAX column
format([Date], "mm/yyyy") // or YYYYMM