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

replace the following expression
DATEADD('bi v_shift'[dateTimeNearestHour],-1,DAY)
with
bi v_shift'[dateTimeNearestHour]-1

  • wasirafi's avatar
    wasirafi
    Helper I
    2 years ago

    still the same error

     

    • Ahmedx's avatar
      Ahmedx
      Super User
      2 years ago

      remove these ( )
      I also advise you to give columns and tables a normal name without spaces or hyphens.

      • wasirafi's avatar
        wasirafi
        Helper I
        2 years ago

        Ahmed,

        I only removed "()" not the content inside it, as that is the second IF criteria.

        I did note your point on not having Spaces and Hypen in the name of the table. The Dataset is owned by 3rd party and i cannot influence that.

         

        The error still remains