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

But i still need to associate for example, the MATIN's value (1076,28) to the right date (February 9) when i filter by date.

 

 

the problem here, is when I select a date ( February 😎 i have to see all the MINUIT's value and for  ( February 9) all the MATIN's value because of is after the midnight and it belong to the next day of 8.

Thanks,

 

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,