Forum Discussion
HOW TO WRITE THIS formula
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 , Need more information
you can have a measure
calculate([measure], filter(Table, Table[Value] >=1 && Table[Value] <=2 ))
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.
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())
amitchandak where we will write this condiiton in measure? or where ?
amitchandak I also have two tables from different servers so how to take value from specific table.
amitchandak this willl include all the values that will be in between these two as I am getting only 1 or 2 values.