Forum Discussion
Solved
ASAP - Need formula
Hi guys, Anyone have formulation to generate weekending data like the picture below (rounded in red line)? I need colum of data that contain week ending date with format just like in the pict at...
Hi Irussaa ,
If you want a DAX formula, you could try the following DAX:
Column = "W" & WEEKNUM ( 'DateDim'[WeekEnding], 1 ) & " " & MONTH ( 'DateDim'[WeekEnding] ) & "/" & DAY ( 'DateDim'[WeekEnding] )
Hi Nathaniel_C
I try to apply
ColumnName =
Text.Combine({[Week]," ",Number.ToText([MonthN]),"/", Number.ToText(Date.Day
(Date.EndOfWeek([date]))})
Inside my data set:
WE = Text.Combine({[DayofWeek]," ",Number.ToText([MonthofYear]),"/", Number.ToText(DateDim[Day]
(Date.EndOfWeek([Date]))})
But its Error.
Can you explain to me what is
[Week]
[MonthN]
Date.Day
(Date.EndOfWeek([date])
Hello Irussaa ,
Here is a link to Power Query Power Query . It is the best place to add Calculated Columns.
However this is a way that you can do it in Power BI.
WE= table[Week] && " " && table[MonthN] && "/" && Day(table[Date]+ 7-WEEKDAY(table[Date],1))In your post you show a table with columns. I took the name of the columns from that picture. You will want to replace "table" in my formula with your table name.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel