Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I have a SQL query that returns a table at present, see below.
I'd like to use Bi to do this rather than a mix of sql and bi. How do i return the current months sales vs the year previous?
I see there are many options to do this, all which which fail to weork for me. Any help apprecated.
Solved! Go to Solution.
It sounds like what you want is something along the lines of PARALLELPERIOD
There are also some techniques here that might help:
http://www.daxpatterns.com/time-patterns/
Not sure what you have tried thus far.
I suppose you want to compare januar 2014 to januar 2015. If so, you can use this DAX formula:
Prior Year Same Month Sales = CALCULATE(
SUM([Sales Amount]);
DATESMTD(SAMEPERIODLASTYEAR(Calendar[DateKey])))
It sounds like what you want is something along the lines of PARALLELPERIOD
There are also some techniques here that might help:
http://www.daxpatterns.com/time-patterns/
Not sure what you have tried thus far.
Thanks for that. Using the forula below i just get a blank column. Why would this be?
YoY = CALCULATE(SUM(order_header_total[oht_foreign_net]),PARALLELPERIOD(order_header[oh_datetime],-1,YEAR))
I suppose you want to compare januar 2014 to januar 2015. If so, you can use this DAX formula:
Prior Year Same Month Sales = CALCULATE(
SUM([Sales Amount]);
DATESMTD(SAMEPERIODLASTYEAR(Calendar[DateKey])))
Thanks for this. A big help.
You are welcome. Hope it saves your time.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
13 | |
8 | |
8 | |
7 |
User | Count |
---|---|
17 | |
13 | |
7 | |
6 | |
6 |