Create new table from existing table with new rows conditionned by aggregation

[Anonymous]

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 ?

[Anonymous · Accepted solution]

This answered my question :
https://community.powerbi.com/t5/Desktop/left-outer-join-using-dax-Multiple-to-Multiple/m-p/219004#M...

[Anonymous]

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

[Anonymous]

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?

[Anonymous]

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

[Anonymous]

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.