Forum Discussion
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 to midnight, 115.47 minuts for February 8, and did the same for the next day of February 9, MATIN is the rest from FRE_NextTime back to midnight, the MATIN, 363.73 min belongs to the next day February 9.
I need to associate the value of MATIN to the right date, in this case FRE_NextTime - Copier.
I tried this:
Thanks a lot,
7 Replies
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
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)/60MATIN = DATEDIFF('Table'[FRE_NextTime-Copier]+'Table'[FRE_NextTime],'Table'[FRE_NextTime-Copier]+TIME(0,0,0)+1,SECOND)/60The result shows:
Here is my test pbix file:
Hope this helps.
Best Regards,
Giotto Zhi
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,
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
