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 shipment number ,dates and a measure "Backlog". Need to calculate the Total backlog of that shipment and consider the latest date value.
Date | Shipment | Measure(backlog) | Required Backlog (last date value) |
30/10/2022 | AX | 720 | 0 |
31/10/2022 | AX | 0 | 0 |
30/10/2022 | BX | 840 | 0 |
31/10/2022 | BX | 0 | 0 |
30/10/2022 | CX | 35 | 0 |
31/10/2022 | CX | 12 | 12 |
Solved! Go to Solution.
Hi,
Please check the below picture and the attached pbix file.
It is for creating a new column
Required backlog CC =
VAR _latestdate =
MAXX (
FILTER ( Data, Data[Shipment] = EARLIER ( Data[Shipment] ) ),
Data[Date]
)
VAR _backlog =
MAXX (
FILTER (
Data,
Data[Shipment] = EARLIER ( Data[Shipment] )
&& Data[Date] = _latestdate
),
Data[Measure(backlog)]
)
RETURN
IF ( Data[Measure(backlog)] = _backlog, _backlog, 0 )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
Please check the below picture and the attached pbix file.
It is for creating a new column
Required backlog CC =
VAR _latestdate =
MAXX (
FILTER ( Data, Data[Shipment] = EARLIER ( Data[Shipment] ) ),
Data[Date]
)
VAR _backlog =
MAXX (
FILTER (
Data,
Data[Shipment] = EARLIER ( Data[Shipment] )
&& Data[Date] = _latestdate
),
Data[Measure(backlog)]
)
RETURN
IF ( Data[Measure(backlog)] = _backlog, _backlog, 0 )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 |
---|---|
46 | |
22 | |
20 | |
15 | |
13 |
User | Count |
---|---|
49 | |
41 | |
39 | |
19 | |
19 |