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
v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

Hi,

 

I am still confused about your requirement.

Could you please explain more about your requirement and expected result for me to help you further.

Thanks!

Expect your reply!

 

Best Regards,

Giotto Zhi

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,