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,
I need help please to calculate a column of average future price by contract (many to many relationship) between two dates.
Solved! Go to Solution.
Hi,
Remove the relationship between the 2 tables. Write this calculated column formula in CAKstartEndDates table
=calculate(average(Benchmark[value]),filter(benchmark,benchmark[value]>=earlier(CAKstartEndDates[Start date])&&benchmark[value]<=earlier(CAKstartEndDates[End date])&&benchmark[FUT]=earlier(CAKstartEndDates[Future])))
Hope this helps.
Hi,
Remove the relationship between the 2 tables. Write this calculated column formula in CAKstartEndDates table
=calculate(average(Benchmark[value]),filter(benchmark,benchmark[value]>=earlier(CAKstartEndDates[Start date])&&benchmark[value]<=earlier(CAKstartEndDates[End date])&&benchmark[FUT]=earlier(CAKstartEndDates[Future])))
Hope this helps.
Hi @Aleph18 , It is not a best practice to connect two tables with a many to many relationship. Instead create a calendar table which will allow you to connect the two tables by a 1 to * relationship from the calendar table to each table.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |