topic Re: Create a table with username and week number / year increasing in DAX Commands and Tips

Create a table with username and week number / year increasing

alexmoller96 — Fri, 28 Jul 2023 10:54:46 GMT

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:

Is that possible using DAX?

Thanks in advance,

Alex

eliasayyy — Fri, 28 Jul 2023 11:01:15 GMT

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

eliasayyy — Fri, 28 Jul 2023 11:11:19 GMT

im not sure but try

New Table =

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

alexmoller96 — Fri, 28 Jul 2023 13:45:08 GMT

Exactly what I needed, thank you so much 🙂