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 everyone,
I'm on a Power BI project needing me to use the LOOKUPVALUE function (I guess)
For example I have:
TABLE 1:
Code_t1 Value Date
A100 100 09/2019
A200 200 09/2019
A100 110 10/2019
A200 210 10/2019
...
TABLE 2:
Code_t2 resultColumn
A100
A100
A100
A100
The goal of the project is to convert an old Excel file used as reporting into a power BI Project.
datas are collected every months on last day.
I have the following formula in resultColumn:
It's working when each Code are unique in Table1, but not with identical values (when we have 2 or more months),
Hi
you can try the following
Add a calculated column on table2
Latest Result =
VAR Current_Code = Table2[Code_t2]
return CALCULATE(sum(Table1[value]), FILTER(Table1, Table1[Code_t1] = Current_Code))
Let me know if it works
Tomas
Hello Tomas,
Thanks you for your answer,
Your function is correct and give me a value wich is the SUM of Value month 1 +Value month 2,
I think I was not working in the right way using column ^^
Is it possible in a measure to filter on date and choose what value to display depending on the date ?
I tried something 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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |