DATESBETWEEN with one fixed date

[Anonymous]

Hi there, I'd like to create a measure that caculates the days between two dates.

The first date is a fixed one. It comes from the creation date of one excel file I uploaded to Power BI. I used "content.folder" here.

The second source is a different table that lists up a certain number of invoices and has a column that displays their "time of entry" into SAP.

Can I use above formular to calculate the time between those two dates?

Thanks in advance for your help

[amitchandak]

Try like

Create as a new column in invoice table

datediff(minx(table,table[Date]),Invoice[created_date],Day)

table is the table where you have the other date

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin

[Anonymous]

I followed your steps but the system gives me this error message:

Too few arguments were passed to MINX function. The minimum argument count for thwe function is 2.

This is what I've entered:

Column = datediff(minx(Ordnerinhalt);Sheet1[Entry Date 2];DAY)

Weird thing is, I can only enter the sheet name "Ordnerinhalt", but not the column I want to refer to.

What am I doing wrong?!

[amitchandak · Accepted solution]

Minx need (Table name , Expression)

something like

Column = datediff(minx(Ordnerinhalt,Ordnerinhalt[Date] );Sheet1[Entry Date 2];DAY)

[Anonymous]

You made my day! It is working.

It's the first week that I'm using Power BI 😃

Have a nice weekend!

[Anonymous]

Hi,

What does it means ? "content.folder"?

Have you tried DATEDIFF("date1","date2",DAY)

I hope that helped you 

[Anonymous]

Hi,

I used "content.folder" within an empty query to get a table that displays the content of the folder my excel file is being saved. Within this table, I have a column that display the original creation date of my excel file.

If I enter DATEDIFF I can't enter the first table. Is there some DAX formular that I need to enter after the first bracket?

[tkirilov]

If you have a relationship between the two tables, then just make sure you use both the table and column names in the formula for the measure like:

Measure = DATEDIFF('Table 1'[DateColumn1], 'Table 2'[DateColumn2], DAY)

[tkirilov]

Hi @Anonymous ,

You should be able to, as long as you have a relationship between these two tables.

Best,

Tom