DAX Syntax Error

[Anonymous]

Hi, 

So i'm having an issue with getting this syntax to work, i'm entirely new to DAX language and am unsure of how to get the request to work correctly. 

What I am hoping to get out of the syntax is a measure which provides a total difference between two sets of dates. Which I can then use to determine how long a process stage takes to complete for each participant involved. I expect there probably is an easier way to create the data but I'm attempting to use the below formula:

Diff = DATEDIFF(Table1[Date1];Table1[Date2];DAY)

However, my main issue is that I would like to use two fields 'Submission Date' and 'Approval Date' to measure the length of time it takes to complete the process stage. I don't think that's feasible with the above expression. Is there an alternative solution? 

Example Data

Company A	Market Re-assurance Information Return	11/07/2017	21/08/2017
Company A	Market Re-assurance Plan	14/08/2017	21/08/2017
Company A	Market and Interface Training
Company A	Business Solution Assessment / Self-Certification Declaration
Company A	Market Entry Assurance Testing	18/09/2017	06/10/2017
Company B	Market Re-assurance Information Return	12/07/2017	27/07/2017
Company B	Market Re-assurance Plan	18/07/2017	27/07/2017
Company B	Market and Interface Training
Company B	Business Solutions Assessment	28/07/2017	21/08/2017
Company B	Market Entry Assurance Testing	21/08/2017	17/09/2017

Thank you for the advice/help!!

[TomMartens]

Hey,

copying your sample data to a Power BI Table "Enter Data", and wachting this table in the Query Editor, I realized that Power BI does not automatically "recognizes" the content of the columns "Date1" and "Date2". The have to be empty and not containing a space.

The empty cells are not empty but contain a single space, I'm not sure if this has happened by pasting the table into your post but is already present in you orignial data, this would explain why your DAX formula won't work as you would expect.

This is just some guesswork because you did not mention what kind of error message you received.

Hopefully this will help you to resolve your problem.

Regards

Tom 

[jthomson]

I'd use the query editor instead and just take one column away from the other (making the resulting column an integer if needed)