DAX Table - contiguous date and value table from import

[Anonymous]

Hello,

I am having difficulty creating a DAX table from an imported table. Basically, what I am trying to achieve is what a VLOOKUP TRUE would achieve in Excel in an effort to create a contiguous date table with values. I can then reference this table using a concatenated reference ItemDate from another table. Here is the input and output sample. Please advise if there is a more efficient alternative to this approach.

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may refer to the post below.

https://community.powerbi.com/t5/Desktop/Find-last-value-based-on-date/m-p/293150#M129228