Solved: Comparing two dates from different tables - Page 2

hakimissimo · ‎06-15-2017

Hello,

Very beginner with PowerBI, i'm trying to compare two dates to determine some elapse time.

two tables : incidents and incident-sla

The tables have a relationship based on incident number (Number).

What i tryed with add a new column : Column = DATEDIFF(Incidents[Opened];'Incident-sla'[start time];DAY)

but i have the error : a single value for column 'start time' in table incident-sla cannot be determined....

Any help appreciated 🙂

++

richbenmintz · ‎06-16-2017

upload to onedrive and include a link

I hope this helps,
Richard

Did I answer your question? Mark my post as a solution! Kudos Appreciated!

Proud to be a Super User!

richbenmintz · ‎06-16-2017

I have fixed your Calc for you and uploaded a new file to the share you created.

Steps:

- Change relationship direction from 'both' to 'single'

- updated the formula to the following, which returns the max('incident-sla'[Start time]) where the 'incident-sla'[Number] = 'Incidents'[Number].

BeforeAck = CALCULATE(max('incident-sla'[Start time]), FILTER('incident-sla', 'incident-sla'[Number] = 'Incidents'[Number]))

- Add a Table visual that show how the max value is returned for each rown in the header and detail tables

I hope this helps,
Richard

Did I answer your question? Mark my post as a solution! Kudos Appreciated!

Proud to be a Super User!

Comparing two dates from different tables