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
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.