DAX Fridays! #76: PARALLELPERIOD

Подписаться 134 тыс.

Просмотров 11 тыс.

50% 1

In today's video, I will go through the DAX function PARALLELPERIOD.
This function allows you to go back to the entire previous period from the current one.
Get Northwind Dataset: • Northwind data source:...
Link to DAX Fridays survey: bit.ly/2MMM4KK
Looking for a download file? Go to our Download Center: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo
► Google +: goo.gl/rvIBDP
► Facebook: goo.gl/bME2sB
#DAXFRIDAYS #CURBAL #DAX #POWERBI #MVP

Опубликовано:

5 апр 2018

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 28

@ajaaskelainen 2 года назад

I find this video helpful even after 4 years after publication :) Thank you, Ruth!

@CurbalEN 2 года назад

Glad to hear!!

@sgk1966 6 лет назад

Thank you Ruth. As usual, very informative and explained beautifully. Thank you once again.

@CurbalEN 6 лет назад

Thanks Gopa, appreciate it! ;) /Ruth

@Victor-ol1lo 6 лет назад

Great video Ruth !!! This function was my life saver with regards to moving annual totals. Enjoy your weekend and as always - Thumbs Up !!

@CurbalEN 6 лет назад

Happy Friday Victor! /Ruth

@FernandoFrenkel 6 лет назад

Hola Ruth, en principio quiero agradecerte por tu trabajo y por todo el contenido que pones a disposición de la comunidad desde hace tanto tiempo, es muy muy bueno, muchas gracias! Simplemente te quería avisar que la resolución máxima de este video es 480 y no se ve muy bien, vos siempre subis los videos con resolución máxima de 720 que se ve bárbaro. Nada más. Saludos!

@CurbalEN 6 лет назад

Gracias Fernando! Qué raro.... siempre subo a la más alta que puedo! Gracias por avisar! /Ruth

@davida.taylor8444 5 лет назад

Very useful. I have an immediate use for this where I've been wondering for a while how I was going to do it until this video. Thanks!

@CurbalEN 5 лет назад

Wonderful!!! Thanks for the feedback! :) /Ruth

@expertopowerbi 5 лет назад

Thank you, very well explained

@rrrprogram8667 6 лет назад

Greattttt... I didn't know this one.. Thanks for the info

@CurbalEN 6 лет назад

You welcome! /Ruth

@ThalassaMavri 6 лет назад

Thank you Ruth!

@CurbalEN 6 лет назад

Glad it helped!! /Ruth

@priyadoesdatascience5141 6 лет назад

Excellent video Ruth. I have a question. I am in a project where i have to transform a excel report to power Bi. However, i want to keep all the past report data in the power bi file and start using the power bi functions from the next period. In excel, i use to copy past value and drag the formula to the next period so that my previous info stay in the report and the formula takes the next period data into calculation. In power BI how can i do that when my data are going to change every week?

@tanababa 6 лет назад

Thank you Ruth. I did not get why the Parallelperiod function sums up the whole year. . Will it always sum up a year? Does it sum up one one level higher?

@MarkCBB86 6 лет назад

ok so, ParrallelPeriod removed the filter context in the table where DateAdd used the filter context? If we had a full year in 1998 on a year level we would get the same amounts?

@CurbalEN 6 лет назад

Exactly, Well said! :) /Ruth

@rassten 6 лет назад

Thank you for a very relevant video, on some confusing functions

@CurbalEN 6 лет назад

Thanks Sten and Happy Friday! /Ruth

@shekharshrestha4072 3 года назад

This is great Video however, I have a question. If we are in 15/05/2021 and need to compare to 2020, Dateadd will give you the result for entire month of May 2020. When we go line by line in Power BI , it will show the data from 2020/01/01 to 2020/05/15 but the total for the previous year will be from 2020/01/01 to 2020/05/31 which is very weird. How do we solve that?

@siddharthanich 2 года назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-oFys4us4umg.html

@rrrprogram4704 6 лет назад

So DATEADD() will act similar to SAMEPERIODLASTYEAR() in this case when YEAR is selected as argument ,right ?

@CurbalEN 6 лет назад

Yes it will, I wonder if sameperiodlastyear is sintax sugar for dateadd, Year.... /Ruth

@giri41 4 года назад

how to filter table with dates in another table , exam campaign date in one table, orders in another.. like to calculate orders where order date > campaign date.. please help