topic Compare this year to last year but only up to equivalent date to today in DAX Commands and Tips

Compare this year to last year but only up to equivalent date to today

owenv — Wed, 23 Mar 2022 14:54:15 GMT

I've got two measures that count unique ID's. One for last year and one for this year look like this:

YTD = TOTALYTD(COUNTA('Alerts (API)'[uid]), 'Alerts (API)'[date].[Date])

YTD last year = TOTALYTD(COUNTA('Alerts (API)'[uid]), SAMEPERIODLASTYEAR('Alerts (API)'[date].[Date]))

These both give the correct values.
However, the version for last year shows all future dates when visualised. For example, when I show the data in a KPI, the target value displays the sum for the whole of last year. What I want is the sum up to today's equivalent date for last year. I've tried filters for this but there's no way for me to filter dynamically. I don't want to have to come in every day and manually add a day.

Re: Compare this year to last year but only up to equivalent date to today

Greg_Deckler — Wed, 23 Mar 2022 14:58:08 GMT

owenv You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, 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 this year to last year but only up to equivalent date to today

owenv — Fri, 25 Mar 2022 10:18:21 GMT

I fixed this using a calendar. I've been able to get by without one until now. Thanks for your input