Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX: Measure if Column="SomeValue

372/5000     Hello My goal is to create a measure that contains a condition on the column (STP code) the measure does not accept the column (can not be determined. Opening time ...
Need Help
  • affan's avatar
    affan
    7 years ago

    Hi Anonymous

     

    What about trying 

     

    Opening time = IF (FIRSTNONBLANK(DWPROD [ST_CODE],1)= "VEL"; CALCULATE (DWPROD [Time stamp 2] -1800) / 3600; (CALCULATE (DWPROD [Time stamp 2] - 3600) / 3600))

     

    If this helped you, please mark this post as an accepted solution and like to give KUDOS .

     

    Regards,

    Affan

Stachu's avatar
Stachu
Icon for Community Champion rankCommunity Champion
7 years ago

what you described should work fine as a calculated column in DWPROD, why not do that?

Opening time = 
IF (
    DWPROD [ST_CODE] = "VEL"; 
    (DWPROD [Time stamp 2] - 1800) / 3600; 
    (DWPROD [Time stamp 2] - 3600) / 3600)
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    thanks for your answer but the STP code is not supported because it's a column

     

    Code dax

     

    • affan's avatar
      affan
      Icon for Solution Sage rankSolution Sage
      7 years ago

      Hi Anonymous

       

      What about trying 

       

      Opening time = IF (FIRSTNONBLANK(DWPROD [ST_CODE],1)= "VEL"; CALCULATE (DWPROD [Time stamp 2] -1800) / 3600; (CALCULATE (DWPROD [Time stamp 2] - 3600) / 3600))

       

      If this helped you, please mark this post as an accepted solution and like to give KUDOS .

       

      Regards,

      Affan