Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
rushank29
Regular Visitor

Track status changes and when the status was changed

So i have a fact table which contains date, sessionid and userid. I have a dim table which contains sessionid and license status. Bothe are connected by sessionid by one to many relationship. I want to track overtime changes by (granularity of day) when was a single persons license status was changed ( day) and also changed to what. (see output table columns in red)

 

I have 5 licnese type blank(which means no status has been recorded),free, pro, semi-pro, max. I want to track changes for every userid. solutions in any form would be appreciated thank you

 

Input tables

Fact table 
   
datesessioniduserid
01.01.23abcperson1
05.05.23cdcperson2
0.4.06.23klaperson1

 

dim table 
  
sessionidlicense status
abcFree
cdcblank
klaPro

 

Output table

dim table   
    
sessionidlicense statusstatus changeddate changed
abcFree 01.01.23
cdcblank  
klaProFree-> Pro0.4.06.23
0 REPLIES 0

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors