create a DAX to derive the earliest date along the entire table

[Wei_Pan]

Hi I am a new Power BI user. I have a table with a date column (displayed in YYYY-MM), I want to create a DAX statement for the earliest date of the entire table based on the scope by using filter/slicer of date. For the screanshot, I wish to have the earliest date as "2020-01" for each row, so I can calcuate the interval between each date on a row level vs the earliest date. I used a "firstdate" function but it return the same date on the row level.

The internal calculation right now is based on a fixed DAX as below:

interval = DATEDIFF(date(2020,1,1),LASTDATE('original data'[date]),MONTH)

but this will not help if the scope of the date is changed by slicer/filter.

Can anyone help on that? I appreciate very much!

[Jpss · Accepted solution]

@Wei_Pan 
consider using 

Earliest Date = CALCULATE(MIN('Table'[date]), ALLSELECTED())

Check the following PBIX for reference Wei_pan_solJpss.pbix

if you find this helpful, consider marking it as a solution

[Wei_Pan]

Hi Jpss, thanks for the help. This works for me now.

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.