Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Minx need (Table name , Expression)
something like
Column = datediff(minx(Ordnerinhalt,Ordnerinhalt[Date] );Sheet1[Entry Date 2];DAY)
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
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:
Minx need (Table name , Expression)
something like
Column = datediff(minx(Ordnerinhalt,Ordnerinhalt[Date] );Sheet1[Entry Date 2];DAY)
You made my day! It is working.
It's the first week that I'm using Power BI 😃
Have a nice weekend!
Hi,
What does it means ? "content.folder"?
Have you tried DATEDIFF("date1","date2",DAY)
I hope that helped you
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?
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)
Hi @Anonymous ,
You should be able to, as long as you have a relationship between these two tables.
Best,
Tom
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |