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.
Hello everyone,
I have two tables like the example below. I want to look up the Campaign into my Product table by the condition that the Launch date is in the period of a Campaign.
I want to use LOOKUPVALUE in DAX but dont know how.
Can we use DAX or another way to solve it?
Thank you
Solved! Go to Solution.
I'm trying to do something similar and for some reason i cannot use the column from the second table in the formula although they have a relationship that is active
Hi,
Share a dataset and show the expected result.
Hello Asish, All,
I am facing a similar problem but also failed to implent the suggested solution as I wasn't allows to use my second table in the FILTER formula.
Here my situation. In a nutstell I would like to look-up exchange rates from my table "Dated Conversion Rate" in order to transform my amounts in the Opportunity table into a standard currency (Euro in this case).
My experiemts got me to something like:
ER = CALCULATE(VALUES('Dated Conversion Rate'[ConversionRate],FILTER('Dated Conversion Rate','Dated Conversion Rate'[StartDate] < Opportunity[ClosedDate]...
but here PowerBI didn't let my CloseDate from the Opportunity get pulled into the equation.
These two tables do not have a relationship but looking at the original example this also wasn't the case there so hopefully this isn't the problem (if it is I am not sure what to do as I don't really have a nice key due to the nature of my date ranges in the conversion table).
Any help is hightly appreciated.
Sascha.
I think it just was a silly bracket issue. This formula appears to work just fine:
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 |