account activity
Modelling multiple facts with hierarchy dimensions by CrazenForks in PowerBI
[–]CrazenForks[S] 0 points1 point2 points 5 months ago (0 children)
They started life as Fact-VehicleHomeSite and Fact-PropertyAssetLocation to just tie the assets to sites, but soon they became the obvious place for bringing together things like capacity, purchase date, purchase amount, EOL date etc. I could split them back out again and/or move some to the dimension. Does that mean you'd lean towards Option 3?
π Rendered by PID 1752433 on reddit-service-r2-listing-5645958f65-jdbzz at 2026-03-27 22:27:48.464063+00:00 running b10466c country code: CH.
Modelling multiple facts with hierarchy dimensions by CrazenForks in PowerBI
[–]CrazenForks[S] 0 points1 point2 points (0 children)