Create a table with username and week number / year increasing

[alexmoller96]

Hi All,

I need help in creating a new table. Here is the problem:

I have a table containing usernames, and a week numbers / year as well as a lot of other items.

I want to create a table separate combining username, each week number and each year them to look a little something like this:

Username	Week	Year
A	1	2023
A	2	2023
A	3	2023
B	1	2023
B	2	2023
B	3	2023

Is that possible using DAX? 

Thanks in advance,

Alex

[eliasayyy · Accepted solution]

im not sure but try 

New Table = 

SUMMARIZE(
'YourTable',
'YourTable'[Username],
'YourTable'[Week],
'YourTable'[Year]
)

[alexmoller96]

Exactly what I needed, thank you so much 🙂

[eliasayyy]

can you please share a sample data from your table to better understand what you want