Forum Discussion

UncleLewis's avatar
UncleLewis
Responsive Resident
4 years ago
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...
Need Help
  • UncleLewis's avatar
    UncleLewis
    4 years ago

    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's avatar
UncleLewis
Responsive Resident
4 years ago

Thanks amitchandak,

That appears to be returning an error complaining that there are too many arguments in the Filter Function

It seems FILTER justs wants : FILTER(<table>,<filter>) 
But your solution seems to have a 3rd argument?

Thanks,
-w