Forum Discussion
Creating a calculated measurement with data from different tables and days
Hi, I'm trying to create a calculation where I can create a ratio between bodyweight and performance in exercises I currently have two seperate tables. One with bodyweights that are collected on...
I ran it and it is giving me the date from which the most recent bodyweight is. The date is accurate, I need the actual bodyweight. Here was my dax formula:
Most Recent Body Mass =
var dateweight=selectedvalue(SPARTA_SCANS2[Date])
return
calculate(min(TESTS[Date]), TESTS[Date]>=dateweight)