Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Anonymous
Not applicable

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

a_calendrier.png

 

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

a_calendrier 2.png

Could any one give me a hand on this please ?

1 ACCEPTED SOLUTION
Anonymous
Not applicable
5 REPLIES 5
Anonymous
Not applicable
Anonymous
Not applicable

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
Not applicable

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
Not applicable

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
Not applicable

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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.