The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi,
I am trying to create a measure "Latest Cost" that takes the most recent cost for a SKU based on the Invoice Date.
I am trying to find these values for the sample data below:
ABC123 = $30.20
XYZ123 = $50.20
BBB123 = $30.90
Supplier SKU | Invoice Date | Purchase Unit Price |
ABC123 | 12/22/2022 | $37.95 |
ABC123 | 1/16/2023 | $34.95 |
ABC123 | 11/9/2023 | $30.20 |
XYZ123 | 10/16/2023 | $50.20 |
XYZ123 | 9/29/2023 | $45.20 |
XYZ123 | 8/31/2023 | $65.20 |
BBB123 | 8/25/2023 | $30.90 |
BBB123 | 8/11/2023 | $31.00 |
Solved! Go to Solution.
Adjust the table name in the following DAX Measure:
Proud to be a Super User!
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LearnAndPractise(Everyday) ) |
Thank you!!
Hi @Tmk123
Please try
Latest Cost =
SUMX (
VALUES ( 'Table'[Supplier SKU] ),
MAXX (
TOPN ( 1, CALCULATETABLE ( 'Table' ), 'Table'[Invoice Date] ),
'Table'[Purchase Unit Price]
)
)
Adjust the table name in the following DAX Measure:
Proud to be a Super User!
Thanks so much!
User | Count |
---|---|
16 | |
8 | |
6 | |
6 | |
5 |
User | Count |
---|---|
23 | |
13 | |
13 | |
8 | |
8 |