Forum Discussion

Richard76's avatar
Richard76
Helper II
7 years ago
Solved

Lookup values

I have a formulae as follows which picks up the working days for each day of the year : YearWdays = LOOKUPVALUE('Working Days'[Dayno],'Working Days'[Date01],'Time'[PK_Date])   I want to amend the...
  • PattemManohar's avatar
    7 years ago

    Richard76  Did you tried using your Pk_Date from your Time dimension table as slicer for your date range ?