Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
14 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
3 | |
3 | |
2 | |
2 |