Forum Discussion
Solved
Calculated Columns UseRelationship Different Dates Return Same Weeks
Hi all, I have 4 different date fields I joined to coporate calendar I created Calculated Columns for each to return the Fiscal Week However, when I review the data in the calculated columns, t...
I was able to resolve this with this Calculated Column Formula from the team at Enterprise DNA
Max Date =
Var CurrentDate = Fact[Start_Date]
Return
MAXX(
FILTER{ALL(FiscalCalendar, FiscalCalendar[Date] = CurrentDate),
FiscalCalendar[FiscalWeek])
Thanks,
-w
UncleLewis , Create new columns like
FWeek_Start = maxx(filter(Fiscal_Calendar, Fiscal_Calendar[Date], fact[Start_Date]), Fiscal_Calendar[FiscalWeek] )
FWeek_Complete= maxx(filter(Fiscal_Calendar, Fiscal_Calendar[Date], fact[Complete_Date]), Fiscal_Calendar[FiscalWeek] )
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8