Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 ?
Solved! Go to Solution.
This answered my question :
https://community.powerbi.com/t5/Desktop/left-outer-join-using-dax-Multiple-to-Multiple/m-p/219004#M...
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
96 | |
90 | |
81 | |
69 |
User | Count |
---|---|
157 | |
125 | |
116 | |
111 | |
95 |