Filter Same Period Last Year With non Consecutive Dates DAX

rlsantos — Thu, 23 Sep 2021 12:04:58 GMT

Hi!! Please, can anyone help me withs this?

I need to build a formula that let me sum current period and too brings me the sum of the same period of the last year.

I have a problem with the SamePariodLastYear, DATEADD, and others Function. It works fine, but when I filter a disticnt months I get the error. Because the function only accepts contiguous dates In Slicer. The problem for what I researched is this, these functions only accept continuous periods, for example January, February, March etc. If I filter for example January, April, September then it gives an error.

If i filter "January" and "September" i need the formula brings me the sum of the same period of the last year, thats what i need.

Re: Filter Same Period Last Year With non Consecutive Dates DAX

Greg_Deckler — Thu, 23 Sep 2021 12:18:34 GMT

rlsantos 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

topic Filter Same Period Last Year With non Consecutive Dates DAX in DAX Commands and Tips

Filter Same Period Last Year With non Consecutive Dates DAX

Re: Filter Same Period Last Year With non Consecutive Dates DAX