I've a table of purchased items stored in the Data Warehouse. The table has almost 20 million records. The table maintains daily transactions and hence the number if rows is huge.
I want to find a way where I can group the entries in the table where I can group items for each month for each customer.
So transfer the example table below:
To be similar to this one
I want to do this as I load the data from the Data Warehouse
Go to Solution.
Hey @YJAMOUS !You can write your SQL like below:SELECT
View solution in original post
Hey @YJAMOUS !
Can you write a SQL to extract the data? If yes, you can try use a group BY, or even create a view to reduce. If you can write a SQL, you can use the Group BY function on Power Query (Group By in Power BI using Power Query Editor - SqlSkull).If this helps, please mark this question as solved to help people find quickly in our community!
Thanks. Yes, I can write SQL statement as I import the data from Oracle DB.
I'm not expert with SQL, so I was wondering how would grouping discard the data and just keep the month and year?
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.