Forum Discussion
Lookup Value
Hi All, I am using a LOOKUP Function. This is the DAX formula I am using. EDU = LOOKUPVALUE('Workbench Export 20220126180530'[Effective Daily Usage],'Workbench Export 20220126180530'[Par...
Anonymous Well, the formulas would be:
Column in Table-1 = MAXX(FILTER('Table 2','Table 2'[Part Number] = 'Table-1'[PartNumber]),[Effective Daily Usage]) Column in Table-1 Lookup = LOOKUPVALUE('Table 2'[Effective Daily Usage],'Table 2'[Part Number], 'Table-1'[PartNumber]) Measure = MAXX(FILTER('Table 2','Table 2'[Part Number] = MAX('Table-1'[PartNumber])),[Effective Daily Usage]) Measure Lookup = LOOKUPVALUE('Table 2'[Effective Daily Usage],'Table 2'[Part Number], MAX('Table-1'[PartNumber]))
Greg_Deckler , I have 2 tables and I have Effective Daily Usage in Table2.
Table-1
| PartNumber |
| 35275913X |
| 35275894X |
| 35087611 |
| 13925560 |
| 35264448X |
| 35087603X |
Table 2
| Part Number | Effective Daily Usage |
| 13815957X | 1105.73214 |
| 9402709 | 128.55357 |
| 12092075 | 220.26786 |
| 16243058 | 4140.39286 |
| 13862570X | 26.78571 |
| 15514195X | 138.44643 |
I am trying to Lookup Effective Daily Usage from the table 2 to table 1 for further calculation in that table.
Thank you!
Megha
Greg_Deckler
Community Champion
Community ChampionAnonymous Well, the formulas would be:
Column in Table-1 = MAXX(FILTER('Table 2','Table 2'[Part Number] = 'Table-1'[PartNumber]),[Effective Daily Usage])
Column in Table-1 Lookup = LOOKUPVALUE('Table 2'[Effective Daily Usage],'Table 2'[Part Number], 'Table-1'[PartNumber])
Measure = MAXX(FILTER('Table 2','Table 2'[Part Number] = MAX('Table-1'[PartNumber])),[Effective Daily Usage])
Measure Lookup = LOOKUPVALUE('Table 2'[Effective Daily Usage],'Table 2'[Part Number], MAX('Table-1'[PartNumber]))
Thank you so much! Greg_Deckler