Forum Discussion
Create new table from existing table with new rows conditionned by aggregation
Hey,
Was a bit difficult to explain the problem in the Subject, sorry if it's not clear enough.
I have an existing (working) table in wich I have :
- date
- ISO week number (WEEKNUM with parameter 21)
- year & week
- rolling period : a period from 4 weeks BEFORE the current week (+ date of the monday of this week) to 4 weeks AFTER the current week (+ date of the monday of this week)
- ISO week number of the beginning of the rolling period
- ISO week number of the end of the rolling period
Its working pretty fine
Now, I want a new table containing :
- the rolling period
- all the weeks between the begenning and the end of the rolling period
I don't have any idea how to get this using DAX... 🤔
Could any one give me a hand on this please ?
This answered my question :
https://community.powerbi.com/t5/Desktop/left-outer-join-using-dax-Multiple-to-Multiple/m-p/219004#M97136
5 Replies
This answered my question :
https://community.powerbi.com/t5/Desktop/left-outer-join-using-dax-Multiple-to-Multiple/m-p/219004#M97136HI Anonymous ,
I dont know if I understood your questions.
But if you want to have a new table from the existing table with only the 2 columns you mentioned than folows these steps.
- Edit queries
-Right click on your existing table and hit on duplicate
- once you have this new duplicate table, keep the columns you want in your new table and get rid of the other columns.
Hope this helps!
Thanks,
Tejaswi
Hey Anonymous ,
The table is already a DAX generated table, and I don't want a simple copy of it, if you take a look, for a rolling period there is just 1 week number.What I want is :
1) get all distinct rolling period
2) for each rolling period, get all the week number that are between the starting and ending week (of the rolling period)
Is it clearer?