topic Re: sales last year in DAX Commands and Tips

sales last year

Anonymous — Mon, 19 Aug 2019 19:05:44 GMT

I'm want to show the entire sales of last year (Sales LY), along with the sales I have YTD, like this:

Date	Sales	Sales LY
January-19	500	232
February-19	450	445
March-19	600	323
April-19	200	324
May-19	400	656
June-19	123	353
July-19	432	345
August-19	344	343
September-19		767
October-19		656
November-19		344
December-19		565

I've played around with this a bit. I could use dateadd, parallellperiod and previousyear functions, but they will not give me the sales for the entire last year, only up to august.

Any ideas?

Re: sales last year

Anonymous — Tue, 20 Aug 2019 04:51:47 GMT

To do time-based calculations you need to follow certain rules. Please read this:

https://www.daxpatterns.com/time-patterns/

The most basic rule is that you should have a proper Date table in your model.

"I could use dateadd, parallellperiod and previousyear functions, but they will not give me the sales for the entire last year, only up to august."

Well, you couldn't use the above functions because they do not work on any date column. They need a Date table. Then they do work correctly.

Best

Darek

Re: sales last year

Anonymous — Tue, 20 Aug 2019 06:24:22 GMT

Thanks, Sherlock. I'm always suprised why there are people out there giving answers which are completly useless. Why do they bother to answer?

Try to imagine that there is a date table. How could the this be resolved?

Re: sales last year

Anonymous — Tue, 20 Aug 2019 06:50:48 GMT

Useless? Well, you get answers based on the information YOU give. We are not fortune-tellers.

Are you saying that the website I've referred you to is USELESS?

Best
Darek

Re: sales last year

Anonymous — Tue, 20 Aug 2019 06:54:36 GMT

Yes, your answer is usesless. The site you are refering to is simply great, but you are not helping. What would be usefull, would be if you could apply the methods Marco is using to my specific problem. That would be of great help.

Re: sales last year

Anonymous — Tue, 20 Aug 2019 06:59:59 GMT

Then you have to wait for others...

Best
D.