Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Here is example of my data. I should get a list of users whose Exchange last active day has been over 30 days ago. The list should be uptadet if the data is updated.
Solved! Go to Solution.
@Anonymous , for that first of all create a table with unser name
user = distinct(Table[disply name])
Join these two tables on disply name
then create a measures like this and use with user table display name
M1 = CALCULATE(countrows(Table]) ,DATESINPERIOD('Date'[Date],MAX(Table[Date]),-30,Day))
measure =
countx(values(user[display name]), if(isblank([M1]), [Diaply Name], blank()))
use the above 2 mesures , use only Measure in visual
use date table for M1
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
Hi, @Anonymous
According to your description, I think you can filter date in PQ using 'date filter' function, then when the data is updated, it will automatically filter the data 30 days ago.
Like this:
If it doesn't solve your problem, Please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , for that first of all create a table with unser name
user = distinct(Table[disply name])
Join these two tables on disply name
then create a measures like this and use with user table display name
M1 = CALCULATE(countrows(Table]) ,DATESINPERIOD('Date'[Date],MAX(Table[Date]),-30,Day))
measure =
countx(values(user[display name]), if(isblank([M1]), [Diaply Name], blank()))
use the above 2 mesures , use only Measure in visual
use date table for M1
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
87 | |
84 | |
68 | |
49 |
User | Count |
---|---|
131 | |
111 | |
96 | |
71 | |
67 |