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.
Hello,
I have a data set which looks like this :
13/02/2017 : box
14/02/2017 : cards
15/02/2017 : bottles
... and so on
But this data set is used with DirectQuery
And like this topic : https://community.powerbi.com/t5/Desktop/cumulative-for-certain-period/td-p/19465
I would like to calculate the cumulative of the NUMBER of item over a period.
However, when I try to use the code used in the previous topic, it is said that "filter" is not supported with DirectQuery.
Is there a solution to also show on a graphe, the cumulative number of item in a graphe with DirectQuery ?
Thank you in advance,
Rob
Please go to "File"->"Option and settings"->"Options"->"DirectQuery" and allow unstrict measures.
User | Count |
---|---|
80 | |
77 | |
63 | |
48 | |
44 |
User | Count |
---|---|
101 | |
43 | |
39 | |
39 | |
36 |