Forum Discussion

magnify-bi-com's avatar
magnify-bi-com
Icon for Helper I rankHelper I
4 years ago
Solved

SWITCH FUNCTION not working for certain visuals for "Total Hours (Previous 30 Days)"

Hey,   I have a SWITCH fucntion that is working for everything but "Total Hours (Previous 30 Days)", I'm presuming this is due to the way I've written the DAX for this measure as opposed to the oth...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    magnify-bi-com , Try like this

     

    Rolling 30 = CALCULATE([Total Hours],DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-30,DAY))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

magnify-bi-com , Try like this

 

Rolling 30 = CALCULATE([Total Hours],DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-30,DAY))

  • magnify-bi-com's avatar
    magnify-bi-com
    Icon for Helper I rankHelper I
    4 years ago

    Thanks Amit, foolishly, I think I just needed to change my MINs to MAXs, that seems to have done the trick.

     

    But your soltuion worked also.

     

    Thanks,

     

    Jon