Forum Discussion
Issue with Missing data in Calculation
Some lessons are included while others are missing in the calculation. Example of Missing Lesson in Calculation For example, a user conducted a lesson on 10/16. Since today is 10/21, the les...
You can try the updated DAX:
Recent7DaysActiveUsers =
CALCULATE (
DISTINCTCOUNT ( USERUNQ[user_id] ),
FILTER (
LESSONN,
TRUNC ( LESSONN[start_time] )
>= TODAY () - 7
&& TRUNC ( LESSONN[start_time] ) < TODAY ()
),
USERUNQ[user_id] = LESSONN[teacher_id]
)
Ensure that start_time in LESSONN is in a date format
💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn
Hi Kedar_Pande ,
Thank you for your reply. I tried it, but an error message appeared:
The expression includes columns from multiple tables, but only columns from a single table can be used in a True/False expression for table filtering.
