Forum Discussion
DATESBETWEEN with one fixed date
Minx need (Table name , Expression)
something like
Column = datediff(minx(Ordnerinhalt,Ordnerinhalt[Date] );Sheet1[Entry Date 2];DAY)
Super UserTry 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:
- amitchandak
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!