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,

 

According to your description, i create a sample to test:

Then try these two columns:

MINUIT = DATEDIFF('Table'[FRE_Time],'Table'[FRE_Time-LIAISON]+TIME(0,0,0)+1,SECOND)/60
MATIN = DATEDIFF('Table'[FRE_NextTime-Copier]+'Table'[FRE_NextTime],'Table'[FRE_NextTime-Copier]+TIME(0,0,0)+1,SECOND)/60

The result shows:

Here is my test pbix file:

pbix 

Hope this helps.

 

Best Regards,

Giotto Zhi

  • 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,