Forum Discussion

wasirafi's avatar
wasirafi
Helper I
2 years ago
Solved

DAX Error when using If Statement with DateAdd

https://1drv.ms/u/s!AjIGh95acxebg6JDCZEPNu4K7yIYQg?e=i1Vuqa  - PBIX File   Hi PB Community   i am trying to use If statement in my DAX expression as below new date1 = IF('bi v_shift'[shiftName]...
DATEADD
if statement
  • Ahmedx's avatar
    Ahmedx
    2 years ago

    pls try this

    Column = IF(
        'bi v_shift'[shiftName]= "night"&& 
        'bi v_shift'[startOffsetMinutes]>55,
        'bi v_shift'[dateTimeNearestHour].[Date]-1,
        'bi v_shift'[dateTimeNearestHour].[Date]
        )

Ahmedx's avatar
Ahmedx
Super User
2 years ago

Is this columns in this table or in another?

  • Ahmedx's avatar
    Ahmedx
    Super User
    2 years ago

    pls try this

    Column = IF(
        'bi v_shift'[shiftName]= "night"&& 
        'bi v_shift'[startOffsetMinutes]>55,
        'bi v_shift'[dateTimeNearestHour].[Date]-1,
        'bi v_shift'[dateTimeNearestHour].[Date]
        )

    • wasirafi's avatar
      wasirafi
      Helper I
      2 years ago

      Thanks Ahmedx  You were very helpful