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.
Solved! Go to Solution.
this is example of my data set (i want calculate "work item id count" per day and display them on visulization)
@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
But this how be do cumulative with a date table
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(date,date[date] <=maxx(date,date[date])))
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(date,date[date] <=max(Sales[Sales Date])))
Can you share sample data and sample output in table format?
Appreciate your Kudos.
this is example of my data set (i want calculate "work item id count" per day and display them on visulization)
User | Count |
---|---|
15 | |
13 | |
12 | |
10 | |
10 |
User | Count |
---|---|
19 | |
15 | |
14 | |
11 | |
10 |