Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a table with the key field (CHAVE), values and dates.
I would like an expression to add only the unique records based on the most recent date.
and in the end I would like to be able to add a table as follows:
AAA 10
BBB 30
CCC 40
XXX 10
YYY 40
ZZZ 90
total 220
Hi @Anonymous ,
Try this measure.
Last Value = LASTNONBLANKVALUE('Table'[DATA],MAX('Table'[Peso]))
Regards,
Harsh Nathani
Please try this measure expression, replacing Table with your actual table name.
Sum of Latest Values =
VAR summary =
ADDCOLUMNS (
VALUES ( Table[CHAVE] ),
"@value", CALCULATE ( LASTNONBLANKVALUE ( Table[Date], MAX ( Table[Peso] ) ) )
)
RETURN
SUMX ( summary, [@value] )
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Does it have to be in DAX, and can you provide the sample data in usable form?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
40 | |
27 | |
20 | |
15 | |
8 |
User | Count |
---|---|
71 | |
48 | |
46 | |
20 | |
16 |