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