Convert time based VLOOKUP to DAX formula

[Daveconva]

My current formula is below with an explanation of my data:

Would it be possible to write this in DAX?

=IFERROR(VLOOKUP(K2,K3:M40000,IF($M:$M=0,2,3),FALSE),"01/01/2010")
Column K = A Unique Value i.e Product 1, Product 2, Product 3 etc…..
Column L = Dates in order of newest to oldest
Column M = Dates in no particular order

So the VLOOKUP looks down the columns and when it sees the next instance of the Unique Key it then gives me the date value in Column M and if there is no new instance of the Unique Key found it returns 01/01/2010.

Column Headings in DAX would be:
Column K = Unique Key
Column L = Date Start
Column M = Date Finished

 

[akice]

The question is a bit vague as you haven't indicated how (or even if) the pivot is setup (what you want on rows/columns), or if this is to be a calculated column(?) or cube formula(?). Do you have a model built? What version of Excel/Power BI are you using?

I'm sure what you want can be done in Dax, but need a clearer understanding of variables so to speak.

 

[Daveconva]

The question is a bit vague as you haven't indicated how (or even if) the pivot is setup (what you want on rows/columns), or if this is to be a calculated column(?) or cube formula(?). Do you have a model built? What version of Excel/Power BI are you using?

I'm sure what you want can be done in Dax, but need a clearer understanding of variables so to speak.

Hi.

Link to example data is below, hopefully edit access allows you to see the formulas I currently have.

https://1drv.ms/x/s!AuSdQxz4X7xXgRXDvAHIjPFjkNdb

Please look at worksheet YILO and YTD in the file (other one is another DAX issue im having)

Columns E,F,G are all similar so if you can just help with one i should be able to copy for the other two columns.

Yes it will be a calculated column

I can sort out pivot chart once I get this new calculated column up and running

Thank you one again