Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi, what I am trying to do is to get the maximum date by Material. I'm using datasets, tables with attributes, and tables with measures.
DAX:
EVALUATE
SUMMARIZECOLUMNS (
'Material'[MAT WRIN0],
'Delivery Date'[DLVD Date],
'Purchase Order'[PO Number],
FILTER (
VALUES ( 'Distributor'[DIST Country] ),
( 'Distributor'[DIST Country] = "Romania" )
),
FILTER (
VALUES ( 'Purchase Order'[PO Status Description] ),
( 'Purchase Order'[PO Status Description] = "Purchase order APPROVED" )
),
"Purchase Order To Be Received Quantity", [Purchase Order To Be Received Quantity]
)
ORDER BY 'Delivery Date'[DLVD Date]
Here is the data extract, and the final result should be like WRIN0 and Max DLVD Date (just one line per WRIN0).
Solved! Go to Solution.
Hi @Anonymous
please use
EVALUATE
FILTER (
SUMMARIZECOLUMNS (
'Material'[MAT WRIN0],
'Delivery Date'[DLVD Date],
'Purchase Order'[PO Number],
FILTER (
VALUES ( 'Distributor'[DIST Country] ),
( 'Distributor'[DIST Country] = "Romania" )
),
FILTER (
VALUES ( 'Purchase Order'[PO Status Description] ),
( 'Purchase Order'[PO Status Description] = "Purchase order APPROVED" )
),
"Purchase Order To Be Received Quantity", [Purchase Order To Be Received Quantity]
),
'Delivery Date'[DLVD Date]
= CALCULATE (
MAX ( 'Delivery Date'[DLVD Date] ),
ALLEXCEPT ( 'Material', 'Material'[MAT WRIN0] )
)
)
ORDER BY 'Delivery Date'[DLVD Date]
Hi @Anonymous
please use
EVALUATE
FILTER (
SUMMARIZECOLUMNS (
'Material'[MAT WRIN0],
'Delivery Date'[DLVD Date],
'Purchase Order'[PO Number],
FILTER (
VALUES ( 'Distributor'[DIST Country] ),
( 'Distributor'[DIST Country] = "Romania" )
),
FILTER (
VALUES ( 'Purchase Order'[PO Status Description] ),
( 'Purchase Order'[PO Status Description] = "Purchase order APPROVED" )
),
"Purchase Order To Be Received Quantity", [Purchase Order To Be Received Quantity]
),
'Delivery Date'[DLVD Date]
= CALCULATE (
MAX ( 'Delivery Date'[DLVD Date] ),
ALLEXCEPT ( 'Material', 'Material'[MAT WRIN0] )
)
)
ORDER BY 'Delivery Date'[DLVD Date]
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
10 | |
10 | |
9 | |
9 |
User | Count |
---|---|
20 | |
13 | |
12 | |
11 | |
8 |