Forum Discussion

sw123's avatar
sw123
Helper III
4 years ago

Help with calculation

Hi, Can someone help me with this? I have three tables: Report, Holes and Recipe.   Report: Report Id: 1 2 3 4 5 6   Holes: Hole Id         Recipe Id           Report Id 1              ...
Need Help
lbendlin's avatar
lbendlin
Super User
4 years ago

You create a standard data model

 

Then you pull in the kg value from the Recipes dimension into the Holes fact as a calculated column

 

kg = related(Recipes[Preset kg])

 

Then you can let the table visual do the rest of the work