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)

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
tkirilov
Icon for Resolver I rankResolver I
6 years ago

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)