Forum Discussion

Regular Visitor

9 years ago

Solved

last year values are missing

Hi, I want to compare the sales of our customers to the last year sales. I just realized, that all the customers, who had sales in last year but do not have sales in this year are not shown i...

Reports

Sedondo
9 years ago
I found a solution which works fine for me.

I changed the filter direction from both to one.
I set a report filter, where I filter the date from the oldest date (in my case 1/1/2010) to the current date (this one i change after every update).

Now, everything is working fine.

Thank you for your support

Sedondo

Regular Visitor

9 years ago

Dear Herbert,

I just created a sample data with the same problem.

https://www.dropbox.com/s/h7027l2bwfjo7ip/sample%20data.pbix?dl=0

If you compare the 2016 report with the 2017 report, you will see that customer D is missing in 2017.

That has something to do with the connection of the date table and the sales table. If you change the filter direction from both to one, you get the right result.

I will try if I will achive anyting with a similar change in my database.

PS: It is not really working - now the dateadd - datesytd fucntion is not working adaquate - now 2016 in total is compared to cumulated May 2017.