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...
  • 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())