Return my last price

[rsaldanha]

Hello,

I have a huge problem and I'm asking you your dedication to help me. 🙂

The problem is:

I have a table with date and prices and I want to populate a visual (table or line chart) with this prices for each day of my calendar table.

So far I just could create a measure but only the days which have price in the Price Table shows in my visual.

I need that measure results like this example:

My example

Please, look this pbix file for example Pbix file 

Thank you in advance.

I'm sorry if this is not a new problem but I could't find any similar in this forum.

[Fowmy]

@rsaldanha 

Check the attached file, you can adapt as per your file:

You can download the file: HERE

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube, LinkedIn

[rsaldanha]

Thank you @Fowmy.
I think I understood what you did with powerquery and I'm appreciated but I'm expecting a measure.

I have thousands of Products and one table with all prices. What I'm trying to do is a line chart with x-axis (date) and y-axis (price at that date) using a slicer to filter by product.

In the future a will do some calculation with this price at date, for example, multiply to quantity of products.

I did a simple pbix file to describe better what is my goal, File 
Thank you a lot for your work to help me.

[Fowmy · Accepted solution]

@rsaldanha

Are you expecting a result like the one below? The last available price is picked if no price found for the current date. you can have multiple products. You can remove Table A and B.

You can download the file: HERE

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube, Linkedin