Forum Discussion

sw123's avatar
sw123
Icon for Helper III rankHelper 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
Icon for Super User rankSuper 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