Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I need a calculated column to get a value with the closest date in another table (Temperature column in items table):
There is no relationship between the tables
I tried this:
Temperature =
var dateitem = Items[Date]
var datetemp=
calculate(MAX(Temperature[Date]),filter(Temperature,Temperature[Date]<=dateitem))
return
calculate(max(Temperature[Temperature]),filter(Temperature,Temperature[Date] = datetemp))
It doesn't work. I get an "insuficient memory" error
Items table has around 25k rows and Temperature table has around 80k rows
Could someone help me?
Thanks,
Thiago
Use the performance analyzer to check which data taking more space.
If the data can sharable please share with me I will check and let you know.
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-performance-analyzer