Forum Discussion
Create new table from existing table with new rows conditionned by aggregation
This answered my question :
https://community.powerbi.com/t5/Desktop/left-outer-join-using-dax-Multiple-to-Multiple/m-p/219004#M97136
HI 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?
HI Anonymous ,
I am still not very much clear.
would it be possible to give us some sample data?
May be show us input data and output you would like to have.
Thanks,
Tejaswi
Hey Anonymous ,
The 1st image is the input data (generated table), and the 2nd image is the desired output.
For each distinct occurs of Rolling period, I want all the weeks between the startign and ending weeks of it.