Show newest price in the table

azaterol · ‎07-20-2023

Hello everyone,

I would like to have the latest entry of the price in a table and not the maximum, variance, average or minimum.

When I right click on the column to get different display options. Unfortunately, there is no way to select the latest price entered.

I have given a date on which the price has been entered for the day.

Example here:

The most recent price from the column should now be displayed in the table visual. Here: $5.00

How can I solve this? Is this possible with Power Query or via a filter that I drag into the table?

Thank you, for help.

ThxAlot · ‎07-20-2023

Merely one simple DAX measure,

Expertise = List.Accumulate(

{Days as from Today},

{Skills and Knowledge},

(Current, Everyday) => Current & Day.LearnAndPractise(Everyday)

)

miTutorials · ‎07-20-2023

Please see this tutorial... You can skip the Order ID and Treatas part in this.

AbhinavJoshi · ‎07-20-2023

Hello @azaterol, are you trying to show the lastest price by date and any other feild like an ID?

azaterol · ‎07-20-2023

yes by the newest Date.

Helpful resources