Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello I need your help again,
here is the measure for it.
Unfortunately, he does not calculate it correctly.
As you can see, the filter is set to 6 months.
Thus, the sold items should be calculated by the number of months.
As an example:
600PCS/ 6 ( months) = 100PCS
@lbendlin
Thanks for your effort but unfortunately this is not what I need.
I am already a small step further and know why PB calculates this incorrectly.
Pictures say more than 1000 words
| 01.05.2022 | 01.06.2022 | 01.07.2022 | 01.08.2022 | 01.09.2022 | 01.07.2022 |
|
123 | 50 | 70 | 80 | 45 | 74 | 60 | 63,2 |
654 |
|
| 60 |
|
|
| 60,0 |
654 | 0 | 0 | 60 | 0 | 0 | 0 | 10,0 |
Empty cells are ignored in both Excel and PB.
Now the question arises can I get around this?
Or would it be feasible if I set the date filter to 6 months that I then get the number 6 as a value.
Look at the here please.
To report on things that aren't there you need to use cross joins and/or disconnected tables.
Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
@lbendlin as requested the test file with the same problem
https://we.tl/t-QXVLdlIibV
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |