Forum Discussion

yugofukuda's avatar
yugofukuda
Helper 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 well.
Could you help me??
 

For Forecast =
CALCULATE(sum(sales), 'Calendar'[WD 22]=17 *I would like to put 17 automatically. )

 

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)

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community 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)