Forum Discussion

yugofukuda's avatar
yugofukuda
Icon for Helper IV rankHelper IV
6 years ago
Solved

lookupvalue using calculate

Hi,   I created the expression as below but I don't know how to insert today´s WD22 automatically (for example, today´s wd22 is 17).  I tried to use calculate or lookupvalue but it didn´t work wel...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    yugofukuda - Maybe:

    For Forecast =
  VAR __WD22 = MAXX(FILTER('Calendar',[Date] = TODAY()),[WD 22])
RETURN
  CALCULATE(sum(sales), 'Calendar'[WD 22]=__WD22)
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

yugofukuda - Maybe:

For Forecast =
  VAR __WD22 = MAXX(FILTER('Calendar',[Date] = TODAY()),[WD 22])
RETURN
  CALCULATE(sum(sales), 'Calendar'[WD 22]=__WD22)