Forum Discussion
How to split the table and create a new table based on column value without using filter
Manjarigoyal1 , Not very clear , why you need break table for this week vs last week
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.Refer if this can help
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8Thanks for your reply.
>> to split the table and create a new table based on column value without using filter
usually, we use function such like
SELECTCOLUMNS function (DAX) - DAX | Microsoft Docs
SUMMARIZECOLUMNS function (DAX) - DAX | Microsoft Docs
If you need more help, please let me know.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
There are only two columns in the original table Site and Data date. the new dates will be added each week to the table.
Thanks for your reply.
>> to split the table and create a new table based on column value without using filter
usually, we use function such like
SELECTCOLUMNS function (DAX) - DAX | Microsoft Docs
SUMMARIZECOLUMNS function (DAX) - DAX | Microsoft Docs
If you need more help, please let me know.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.