Forum Discussion
Using another table's values in calculate
Hi, I am hoping someone can help. We are trying something with my company's cash forecasting. We get a report every week that lists every invoice that has come in on the ledger. These willl have ...
Hi,
If I understand you correctly, you can use the RELATED function in this instance, something like:
Measure 1 week out = CALCULATE([Measure Total Value], 'Column Adjusted Week'[Week Number] = RELATED('Week'[Week Number]) + 1)
Thanks for the quick response. Unfortunately that didn't work - I get the following message:
So, looking at the relationship: