Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi,
Need help in solving the below issue.
I have a data from January to decemeber but need to show only data till last month -1.
Example: the first table show's the total qty , when i calculated the cummulative total it is showing for dec also. I tried to filter out but is not now working.
Solved! Go to Solution.
@Anonymous ,
Try with date table like
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=maxx(date,dateadd(date[date]),-1,month)))
User | Count |
---|---|
84 | |
82 | |
66 | |
52 | |
48 |
User | Count |
---|---|
100 | |
49 | |
42 | |
39 | |
39 |