Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Associate a value to a specific date

Hi everyone,   Please I need your help, I'm calculating the time past by day, on this example the FRE_NextTime finished on the next day, then i calculate MINUIT that mean from FRE_Time...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Here is the real data,

My expected result appears on TIME column with those conditions:

if FRE_NextTime - Copier <> FRE_Time - LIAISON then :

 

MINUIT: 

IF(TBL_RESULTS[FRE_Time - LIAISON]<>TBL_RESULTS[FRE_NextTime - Copier];HOUR(24)-TBL_RESULTS[FRE_Time - Copier]

MATIN:

IF(TBL_RESULTS[FRE_Time - LIAISON]<>TBL_RESULTS[FRE_NextTime - Copier];(TBL_RESULTS[FRE_NextTime]-HOUR(24)
 
So:
I want to: TIME = if FRE_NextTime - Copier <> FRE_Time - LIAISON ; associate every MINUIT's value to FRE_TIME - LIAISON OR/AND associate every MATIN's value to FRE_NextTime - Copier
 
Thanks a lot,
v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

Hi,

 

According to your posted screenshot, please try this column:

Time =
IF (
    'TBL_RESULTS'[MINUIT] <> BLANK (),
    'TBL_RESULTS'[MINUIT],
    'TBL_RESULTS'[CYCLE]
)

 

Best Regards,

Giotto

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

     

    What about MATIN status?

     

    Tks,