Forum Discussion
Distinct count Active User for 3 last month
Hi yanivsab
Generally, you can try to check the linked tutorials:https://www.youtube.com/watch?v=m1uupRDWzQw
https://www.youtube.com/watch?v=cfDyNPQIJtA
And the linked discussion:
For a more specific solution, please attach the data to work with in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Super UserHi,
Create a Calendar Table with calculated column formulas for Year, Month name and Month number. Sort the Month name column by the Month number. Create a relationship (Many to One) and Single from the Timeframe column of the User Activity Export table to the Date column of the Calendar Table. To your Table visual, drag User ID. This DAX measure pattern should work
Measure = countrows(filter(summarize(calculatetable(calendar,datesbetween(calendar[date],edate(eomonth(today()),-4)+1,eomonth(today(),-1))),values(_UserActivity_Export[UserId]),"A",calculate(countrows(_UserActivity_Export),_UserActivity_Export[Has Activity]=true),[A]=0))Hope this helps. If it does not, then share the download link of the PBI file and show the expected result.