Forum Discussion

BICrazy's avatar
BICrazy
Helper II
5 years ago
Solved

Setting Date Parameters

Hi there Community, I need help with a DAX Measure, please.  The below measure is working fine, however, I now need to make an amendment to the commission from 100 to 110 from the 1st Feb 2021.  B...
  • amitchandak's avatar
    amitchandak
    5 years ago

    BICrazy , replace VAR COMMISSION with this

     

    VAR COMMISSION = if(max('Calendar'[Date]) <date(2021,02,10) ,100,110)

     

    or

     

    VAR COMMISSION = calculate(100,filter('Calendar','Calendar'[Date] <date(2021,02,10))) + calculate(110,filter('Calendar','Calendar'[Date] >= date(2021,02,10)))

BICrazy's avatar
BICrazy
Helper II
5 years ago

amitchandak 

This measure worked perfectly VAR COMMISSION = if(max('Calendar'[Date]) <date(2021,02,10) ,100,110).  I just changed the date from (2021,02,10) to (2021,02,01).  Thank you