Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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