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 "...
Minx need (Table name , Expression)
something like
Column = datediff(minx(Ordnerinhalt,Ordnerinhalt[Date] );Sheet1[Entry Date 2];DAY)
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
Super User
Super UserMinx 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!