Forum Discussion
DATESBETWEEN with one fixed date
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
Minx need (Table name , Expression)
something like
Column = datediff(minx(Ordnerinhalt,Ordnerinhalt[Date] );Sheet1[Entry Date 2];DAY)
8 Replies
tkirilovResolver I
Hi Anonymous ,
You should be able to, as long as you have a relationship between these two tables.
Best,
Tom
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)
- amitchandak
Super User
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 LinkedinI 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
Minx need (Table name , Expression)
something like
Column = datediff(minx(Ordnerinhalt,Ordnerinhalt[Date] );Sheet1[Entry Date 2];DAY)