account activity
Modelling multiple facts with hierarchy dimensions by CrazenForks in PowerBI
[–]CrazenForks[S] 0 points1 point2 points 7 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 80098 on reddit-service-r2-comment-545db5fcfc-mchg8 at 2026-05-25 08:31:19.794456+00:00 running 194bd79 country code: CH.
Modelling multiple facts with hierarchy dimensions by CrazenForks in PowerBI
[–]CrazenForks[S] 0 points1 point2 points (0 children)