Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Dear all,
I hope you are well.
I have three different tables:
- A calendar table;
- A visitors table with the logins, one row represents one login.
I calculate the Weekly Active Users (WAU). The formula I use requires me to compute it for each date, like that:
I would need to have the WAU as measure for the very last date of the period and not depending on/for each date, so, one datapoint for each month.
Here is the original formula:
Thank you in advance for your help! I appreciate it.
I am at your disposal should you have any questions.
A
Solved! Go to Solution.
@Anonymous , for that you need a measure like
MTD Sales = CALCULATE(lastnonblankvalues('Date'[Date],DISTINCTCOUNT('Visitors'[Visitor ID])) ,DATESMTD('Date'[Date]))
@Anonymous , for that you need a measure like
MTD Sales = CALCULATE(lastnonblankvalues('Date'[Date],DISTINCTCOUNT('Visitors'[Visitor ID])) ,DATESMTD('Date'[Date]))
I would need to keep the base formula the same as it is a metric.
I worked around it, it works! I did not know the function LASTNONBLANKVALUE.
Thank you amitchandak! You are an angel!
User | Count |
---|---|
14 | |
10 | |
7 | |
6 | |
5 |
User | Count |
---|---|
30 | |
19 | |
12 | |
7 | |
5 |