topic Re: Compare YTD to same dates last year in DAX Commands and Tips

Compare YTD to same dates last year

bininja — Mon, 30 Mar 2020 14:58:45 GMT

Hi guys,

I am trying to create a barchart where I would like to show sales per month for current year with comparison to same period last year, with the possibility to drilldown to per day. The difficulty I am having is to be able to compare current month to same dates for last year current month. It sums up the whole month for last year which makes it wrong.

I have a Calendar table but I can not use it as a slicer and use SAMEPERIODLASTYEAR as I cannot add date-slicer to the report as it is supposed to be sent out on emails.

Any help is appriciated.

Samle file: https://easyupload.io/0x3jpg

Re: Compare YTD to same dates last year

Greg_Deckler — Mon, 30 Mar 2020 14:11:26 GMT

See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008

Re: Compare YTD to same dates last year

bininja — Mon, 30 Mar 2020 14:20:31 GMT

Greg_Deckler Thanks for your quick reply. Unfortunately your solution does not look to cover my problem. I am looking for a solution on date-level but your solution look to be on month level.

Re: Compare YTD to same dates last year

Greg_Deckler — Mon, 30 Mar 2020 14:24:17 GMT

TITHW covers a general technique around date filtering so the basic concept can be used for any situation. However, it is not really possible to cover the nearly limitless permutations. If you could share sample data I could be more specific. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Re: Compare YTD to same dates last year

bininja — Mon, 30 Mar 2020 14:59:55 GMT

Greg_Deckler Thanks. I just added a sample file to my post. Please take a look. I am looking to distinctCount the visitorIds.

Re: Compare YTD to same dates last year

bininja — Mon, 30 Mar 2020 15:30:31 GMT

Greg_Deckler I got it sorted out by using filter and variables. Thanks for your time 🙂