Hey everyone,
I'm new to Power BI and DAX and am trying to aggregate data from multiple time series tables into a results table.
I've spent most of the day reading docs but am a bit stuck.
My table structure is loosely like this:
Organization
Service: OrganizationId (FK), ServiceType
ServiceType1Data: ServiceId (FK), Data1, Data2
ServiceType2Data: ServiceId (FK), Data3, Data4, Data5
ServiceType3Data: ServiceId (FK), Data6. Data7, Data8, Data9
One Organization can have multiple Services, and each Service has a time series list of updates.
I would like to have a table of most recent data for each organization such as:
MostRecentData: OrganizationId, Time, Data1, Data2, Data3, Data4...
If that isn't quite feasible, I'd at least like to know how to reference the most recent data for each service type and relate that back to an organization (Data -> ServiceId -> OrganizationId). Not quite sure how to make that double jump there.
If it makes a difference, my data is from SQL Server as DirectQuery.
Thank you for the assistance!
Jonathan
