topic Re: Same period Previous Year for the selected Dates in DAX Commands and Tips

Same period Previous Year for the selected Dates

Tanyag — Wed, 02 Sep 2020 18:50:08 GMT

I am trying to write a DAX to filter the Data for the same periof prior year. I could write DAX for current year and tried using "samepreiod lastear" but it doesnt give me required result. Can someone help me apply the logic

Where as

MinMax = CALCULATE(MIN('Sales'[Actual Ship Date]),ALLSELECTED(Sales[Actual Ship Date]))

MaxMDate = CALCULATE(MAX(Sales[Actual Ship Date]),ALLSELECTED(Sales[Actual Ship Date]))

Re: Same period Previous Year for the selected Dates

Greg_Deckler — Wed, 02 Sep 2020 19:40:35 GMT

Tanyag - Well, there are things like PREVIOUSYEAR and other TI functions. 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

Otherwise, Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, 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

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Re: Same period Previous Year for the selected Dates

amitchandak — Thu, 03 Sep 2020 06:17:13 GMT

Tanyag , You need to use date table for that. You can also use trailing year measure

example

Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))

Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions

Video -https://youtu.be/Qt0TM-4H09U
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184

Appreciate your Kudos.

Re: Same period Previous Year for the selected Dates

Anonymous — Thu, 03 Sep 2020 09:16:18 GMT

Time-intelligence requires a proper Date table. You can't get away without it.

Re: Same period Previous Year for the selected Dates

Tanyag — Thu, 03 Sep 2020 19:29:14 GMT

Thanks amitchandak Greg_Deckler I was able to resolve it using https://bielite.com/blog/last-12-months-from-selected-date-trailing-12-months-ttm/