Forum Discussion
Jakob_BI
3 years agoHelper I
Last available date value vs current date value increase or decrease
Hi all, Step 1. I need help to calculate if there is an increase or decrease in value between the latest dates for a given batch on a specific product. Step 2. I need to count if there i...
Anonymous
3 years agoNot applicable
You dont need more sample data.
just need to create 2 measures or 2 columns that calculate those 2 highlighted columns.
the first column need to compare current value vs last value for that given product, looking at the purification date for the last date where there was a value for that product.