Forum Discussion

Matren's avatar
Matren
Frequent Visitor
2 years ago
Solved

DAX Last Record Value

Hello Everyone,   How could I write a DAX expression with existing columns (Date, Product, Value) to generate a new column (Last Record)?   Basically, it is taking the last Value for a Product an...
Matren's avatar
Matren
Frequent Visitor
2 years ago

Hi ThxAlot ,

 

Thanks! I think this looks right.

 

I will check out the solution with my implementation and then accept the solution.

 

Have a good day,

Matren

Matren's avatar
Matren
Frequent Visitor
2 years ago

Hi ThxAlot ,

 

I was able to add sparklines showing the trend over time for products.

 

It would be great if Microsoft added "Last" to the summation, instead of having to write DAX code to produce sparklines showing how a value changes over time.

 

Thanks Again!