Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I've a table with daily targets per date and another table with sales quantity.
The sum of all daily targets is 248 but since we are missing a day with sales the cumulated target in the gauge is also missing the target for the day with no sales.
As you see below, i'm missing bot the target and the sales (zero) in the table.
The table fomula is:
Results = SUMMARIZE(Sales;
Dates[DateCYFY2020];
"Budget"; SUM(Budget[Budget]);
"Sales"; SUM(Sales[quantity]);
"Target"; SUM(Budget[+30%])
)
Should be:
Day | Budget | Sales |
1 | 2 | 1 |
2 | 2 | 2 |
3 | 2 | 3 |
4 | 2 | 0 |
5 | 2 | 2 |
What it looks like (the day is missing instead of showing value 0 in Sales)
Day | Budget | Sales |
1 | 2 | 1 |
2 | 2 | 2 |
3 | 2 | 3 |
5 | 2 | 2 |
Solved! Go to Solution.
Hi @Anonymous
Instead of a new table, with correct relationship, it works as well.
Hi @Anonymous
Instead of a new table, with correct relationship, it works as well.
Hi,
you SUMMARIZE the data on the base of the Sales table.
If there is no sales row, it cannot be summarized.
Please give Kudos for support.
If I answered your question, please mark my post as solution, this will also help others.
Hi,
So if I change the input table to Budget (where I have a value for the day where I am misssing sales it'll work?
I assume it, but I have no further information about your model to validate it.
Otherwise, you can also implement the proposal of Maggie Li.
Please give Kudos for support.
If I answered your question, please mark my post as solution, this will also help others.
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
73 | |
65 |