Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 "...
Need Help
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    6 years ago

    Minx need (Table name , Expression)

     

    something like

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

tkirilov's avatar
tkirilov
Icon for Resolver I rankResolver I
6 years ago

Hi Anonymous ,

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

Best,

Tom