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 im not even sure it this is possible but i give it a try
1. If i Have two tables (Table A and Table B)
2. It i create a table visual whit a date slicer and pick the date 2018-01-01 to 2018-01-05 the visual will display something like this.
(It vill group Name and sum number)
3. To the question: Is it possible to from here to lookup value in a table based on the name and number column and display it in the visual table?
To claryfi Visuals table is a visual and i realise that lookup value is the same value that is already in the visual, but i think you
get idea.
// Petter
@Petter120 Is it something like this you are looking for ?
LkpNumber = LOOKUPVALUE(Test75Lkp[LkpNumber],Test75Lkp[Name],Test75Data[Name],Test75Lkp[LkpNumber],CALCULATE(SUM(Test75Data[Number]),FILTER(Test75Data,Test75Data[Name]=EARLIER(Test75Data[Name]))))
Proud to be a PBI Community Champion
i'm not sure but try this
add column in Table A
new column =
var sumNmbr = sumx(filter(tableA;earier([Name])=[Name]&&earlier([Date])=[Date]);[Number])
var lookUpB = lookupvalue(tableB[Lookup number];tableB[Name];tableA[Name];tableB[Lookup number];sumNmbr)
return lookUpB
Try this MEASURE as well
Measure = LOOKUPVALUE ( TableB[Lookup number], TableB[Name], SELECTEDVALUE ( TableA[Name] ), TableB[Lookup number], SUM ( TableA[Number] ) )
Measure = LOOKUPVALUE ( TableB[Lookup number], TableB[Name], SELECTEDVALUE ( TableA[Name] ), TableB[Lookup number], SUM ( TableA[Number] ) )
This one works great, but i just realised i was asking the question wrong.
What im trying to figure out is a measure that:
1. Match the name in Visual table and Table B (Lookup table)
2. And Match the number Visual table and Table B (Lookup table)
3. And Returns the corresponding skop to visual table
Sorry about my ambiguity
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |