cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Accepted Solutions
Highlighted
Super User II
Super User II

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

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/





Did I answer your question? Mark my post as a solution!

Kudos will be cherry on the top 🙂


Proud to be a Super User!




View solution in original post

5 REPLIES 5
Highlighted
Super User V
Super User V

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

Hi,

Share a simple dataset and show the expected result.


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

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

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)

Highlighted
Super User II
Super User II

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

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/





Did I answer your question? Mark my post as a solution!

Kudos will be cherry on the top 🙂


Proud to be a Super User!




View solution in original post

Highlighted
Helper I
Helper I

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

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?

Highlighted
Helper I
Helper I

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

It worked.

Many thanks.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors