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
Haidannx
Helper I
Helper I

How to show data of users don`t active in the last 30 days?

Hello everyone,

 

I have a problem like below:

I have a Fact table said which user active on my system, the date they active,...

and another Dimtable of total User of the system.

Now how can i know which user activate in the last 30 days? 60 days? 90 days?

 

Many thanks

1 ACCEPTED SOLUTION

Hello@Haidannx 

 

Please find the sample solution file here

 

Regards,
Vivek

If it helps, please mark it as a solution

Kudos would be a cherry on the top 🙂

https://www.vivran.in/

View solution in original post

5 REPLIES 5
Ashish_Mathur
Super User
Super User

Hi,

Share a simple dataset and show the expected result.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Fact table

User idDate createdTags
12020 - 02 - 05add
22020 - 01 - 18buy
32020 - 01 - 18 create
42019 - 01 - 31add
52019 - 05 - 14tag

 

Dim table

 

User IDName
1A
2BC
3C
4D
5#
9

5

 

Now how can i know which User doesn`t active in the last 30 days ? (it supposed to be user id 3, 4, 5, 9)

Hello@Haidannx 

 

Please find the sample solution file here

 

Regards,
Vivek

If it helps, please mark it as a solution

Kudos would be a cherry on the top 🙂

https://www.vivran.in/

It worked.

Many thanks.

Hi @vivran22 

Many thanks for your answer

Still i find out that those user doesn`t active at all since the day their account were created will not appear in fact table

how can i calculate those accounts too?

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.