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.
Hi,
I have tried several functions, lookupvalue, Max, Maxx and other options suggeted in this forum, but I seem not be able to find the right solution.
In regard to the below screenshot:
I need in an other POWER BI Table/ Column ( WO[LAST_,PROD DEL DATE] ) the CO[CO_PROD_DELIVERY_DATE],
where the CO[CO_ESTIMATE_STATUS] not equal to "Cancelled"
Search Criteria from the other column is: WO[WO_NUMBER]
FYI the CO[CO_ESTIMATE_ID] is a uninque number.
This Table is CO
So I figured to search on WO[WO_NUMBER] in the CO[WO_NUMBER] and then via the highest CO[CO_ESTIMATE_ID] number selecting the CO_PROD_DATE I need.
So thought to find of conditional LOOKUPVALUE, but I cant get it working, probably that I'm just exploring PBI.
Any sugestions?
Brgds Kees
Solved! Go to Solution.
Found via coworker the soution.
Create a Measure, content;
Found via coworker the soution.
Create a Measure, content;
Hi @Kees
Try the below
Search Date =
var _Agg = SUMMARIZE(TestTable, TestTable[WONumber], "CO", MAX(TestTable[CONumber]), "ES", MAX(TestTable[EstimateID]), "DATE", max(TestTable[Date]))
RETURN
MAXX(_Agg, [DATE])
Thanks
Hari
Could not get it working like this.
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 |
---|---|
15 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
26 | |
3 | |
2 | |
2 | |
2 |