Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
hi,
i have 2 unrelated tables in an SSAS tabular mode:
Location Values:
AcctId, LocationValue, Date
1 1,000,000 6-30-2017
1 500,000 6-30-2017
1 300,000 6-30-2017
Premium Values:
AcctId, PremiumValue, Date
1 100,000 6-30-2017
I want to bring the sum of the LocationValues into the PremiumValues table by joining on the AcctId and Date fields.
So in the Above example, i should end up with this in the PremiumValues table:
Premium Values:
AcctId, PremiumValue, Date, LocationValue
1 100,000 6-30-2017 1,800,000
I think LookupValue will work, but not sure of the syntax. I tried of couple of ways, but it keeps failing.
Scott
User | Count |
---|---|
5 | |
4 | |
4 | |
2 | |
2 |
User | Count |
---|---|
8 | |
6 | |
4 | |
4 | |
4 |