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 = IF (DWPROD [ST_CODE] = "VEL"; CALCULATE (DWPROD [Time stamp 2] -1800) / 3600; (CALCULATE (DWPROD [Time stamp 2] - 3600) / 3600))
thank you in advance
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

3 Replies

  • 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