Forum Discussion

UncleLewis's avatar
UncleLewis
Icon for Responsive Resident rankResponsive 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
Icon for Responsive Resident rankResponsive Resident
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