Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hope you have great day,
I need support to get the out put in new column as "Week 1 January 22" from the date table created using calender auto showing one year dates in power query.
Thanks in advance
Solved! Go to Solution.
just like what @Rudy_D said, you can't create the column in PQ if you use dax to create a table.
pls try this
Proud to be a Super User!
just like what @Rudy_D said, you can't create the column in PQ if you use dax to create a table.
pls try this
Proud to be a Super User!
i created simple date table with column name "Date" using "CALENDARAUTO()" expression
If you used Calendarauto(), I guess you have created the table in Dax.
So you cannot add the column requested using power query. But I can show you how to do it in Dax.
Yes i am using DAX, appreciated to have a solution thanks
You can use this formula :
hi,
your solution is useful to me, another quick question, how i can repeat the week numbers when a month name changes like week 1, week2, week3 and week 4 for January but i need to repeat starting from week 1 to week 4 in february and so on
you can try this
Column 2 = "Week " & ROUNDDOWN(('Table'[Date]-min('Table'[Date]))/7,0)+1 &" "& format('Table'[Date],"mmmm")&" "& right(year('Table'[Date]),2)
Proud to be a Super User!
Hi,
Could you please describe the date table from which you want to create the new column ?
Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |