Forum Discussion
Comparing two dates from different tables
upload to onedrive and include a link
Hi hakimissimo,
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
Hi Richbenmintz,
How can i attach my pbix file to the post?? (very newbie :-)
++
upload to onedrive and include a link
Hi hakimissimo,
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 have uploaded pbix file on my g drive : https://drive.google.com/drive/folders/0B74jBoLmjb1yTkktS2tONC1WM00
ask access please.