Greengrass
New Member
- Joined
- Nov 6, 2021
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
Hello!
I am trying to create a measurement in Power BI Desktop based on a Tabular model created in SSAS, so I am limited to measurements.
I want to create a measurement which will show the last Activity date per Customer, as illustrated in the table below:
Where the "Customer Name" is located in a table called "Customer Site TCRM for Activity and Opportunity" and "Last Activity" is the created measurement and the date field to be used is "Date - Activity" found in the "Calendar - Activity" table.
The relation between the three tables looks like this:
How should the measurement be written so it includes the last Activity date per Customer Name?
I am trying to create a measurement in Power BI Desktop based on a Tabular model created in SSAS, so I am limited to measurements.
I want to create a measurement which will show the last Activity date per Customer, as illustrated in the table below:
Where the "Customer Name" is located in a table called "Customer Site TCRM for Activity and Opportunity" and "Last Activity" is the created measurement and the date field to be used is "Date - Activity" found in the "Calendar - Activity" table.
The relation between the three tables looks like this:
How should the measurement be written so it includes the last Activity date per Customer Name?