Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

HOW TO WRITE THIS formula

Hy all I want to write a formula that if this thing is in between 1 & 2 then show the output ,Please tell me how to write this in power bi it will be helpful please reply as fast as you can. , it wou...
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous a new column, assuming column are from same table

     

    if([DeviationEscalationDate] >= [mfg_ww_begin_datetime] && [DeviationEscalationDate] < = [mfg_ww_end_datetime] , [MFG_YEAR] & "-" & [mfgworkweek] , blank())

Anonymous's avatar
Anonymous
Not applicable
4 years ago

 if DeviationEscalationDate  is between ww.[mfg_ww_begin_datetime] and ww.[mfg_ww_end_datetime] then  show MFG_YEAR+mfgworkweek 

Please write this in formula and let me know if it can be done or not.

 

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous a new column, assuming column are from same table

 

if([DeviationEscalationDate] >= [mfg_ww_begin_datetime] && [DeviationEscalationDate] < = [mfg_ww_end_datetime] , [MFG_YEAR] & "-" & [mfgworkweek] , blank())

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    amitchandak where we will write this condiiton in measure? or where ?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      amitchandak I also have two tables from different servers so how to take value from specific table.

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    amitchandak this willl include all the values that will be in between these two as I am getting only 1 or 2 values.