Forum Discussion

sameergupta60's avatar
sameergupta60
Helper IV
3 years ago

Dax Help

Hi Team   If my RCC level is on R07 then my BW should start if it started showing 1, or not showing zero in another column we need dax for the above querry attaching excel with data Case 1   ...
Need Help
ryan_mayu's avatar
ryan_mayu
Super User
3 years ago

is the BW column the expected output?

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    3 years ago

    pls check if this is what you want

     

    Column = 
VAR _f=left('Table'[Levels],1)
VAR _a=maxx(FILTER('Table','Table'[Levels]="R07"),'Table'[Levels])
VAR _bw=minx(FILTER('Table',_f="R"&&not(ISBLANK('Table'[Block Work start date]))),'Table'[Block Work start date])
return if(_f="R"&&_a<>""&&'Table'[Block Work start date]=_bw,1)

    • sameergupta60's avatar
      sameergupta60
      Helper IV
      3 years ago

      thanks for your support,

       

      but my query is if my RCC is on R07 then block work should start date ideally.

       

      if block work has not started at with respective RCC floor r07 then it should be 0 or 1.

       

      • ryan_mayu's avatar
        ryan_mayu
        Super User
        3 years ago

        could you pls provide the sample data which includes different cases and the expected output based on that?