DAX Fridays!

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

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

50% 1

Get Northwind Dataset: • Northwind data source:...
Link to DAX Fridays survey: bit.ly/2MMM4KK
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
curbal.com/product/sponsor-me
Many thanks in advance!Here you can download all the pbix files: curbal.com/donwload-center
▲▲▲▲▲▲▲▲▲▲
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
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#daxfridays #curbal #SUBSCRIBE

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

2 янв 2020

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@AliAbbas-ik9ix Год назад

Excellent ... its work great for my porject ... Jazak Allah. Allah Pak ap ko Eman ata kry. Ameen.

@madhurishirsat567 Год назад

I always come here at Curbal with problem and definitely get it resolved 100% every time!! You are doing great great work!! Thank you so much.

@CurbalEN Год назад

Thanks!

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

It's nice to see the DAX trick from you. Thank you Ruth...

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

Thanks Ayobami! /Ruth

@ommm4169 11 месяцев назад

Thank you so much.. you have solved a big issue for me

@CurbalEN 11 месяцев назад

Delighted to hear :)

@klandestin83 5 месяцев назад

thank you, very usefull for me that, how about filter with working day only in a month?

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

Hi Good Morning, One scenario, We have Forecast Barrels out report we want calculate no of days missing in the report.? Alredy we have days of forcast measure Days of forecast = IF(OR(Source_Activity[Count of movement days]'date'[total movment days]), Source _Activity[Count of movement days])

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

Thanks Ruth! Really helpful:)

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

🎉🎉 /Ruth

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

Thanks Ruth Very interesting and usefull.

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

Great! /Ruth

@richardtorrenueva5512 2 месяца назад

Thank you... you resolve mine

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

Thanks for brilliant videos, you lighten up darkish winter evenings. Could you prepare video regarding working days with exception, how to treat epiphany 6.1 as additional working day (wd 2's being 3.1 and 6.1), without tainting working day calendar. What approach you recommend on duplicating working day? Thanks a lot in advance

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

Hi Esa, I will add it to my to do list :) /Ruth

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

@@CurbalEN Hi Ruth, how nice! Looking forward :)

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

super good, so good explanation. Greetings from Västerås

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

Grannar!! Vad kul :)

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

love this videos, would of loved if this was wrapped in day() rather and datediff() for more clarity and less calculations

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

Thanks for sharing Jake! /Ruth

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

Nice video Ruth Mam. A request, How to filter the Sales Value with each EOMONTH.(Like on 31st Jan 2021 - sales value, 28 Feb 2021 - Sales Value, 31 Mar 2021 - Sales Value, and current month date Sales value ie; Today 20.04.2021 sales value)

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

i need to get the no of days in a month as per its current date. suppose if today is 5th then i need to get no of days as 5 for current month and for last month i need to get the max month days. the current month days need to update as per it date. please help

@uzairrasheed3495 Год назад

Do you have a solution that How to calculate Days left in current month ?

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

Hi, Curbal my question to you is for example: my insurance date is 03/05/2019 i need to add 18 to it. and i want 03/11/2020 how can we get it.

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

can you please share how you got 7 for oct month w.r.t current date

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

Thank you! I would be helpful if you could show how to use this to calculate the occupation rate of room during a year. Best regards

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

Noted for a future video :) /Ruth

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

@@CurbalEN That would be so great! Thanks

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

Hi Ruth. I remember that you shared one video solving this problem but I can’t find it. I need compare cumulative sales of the current month vs cumulative sales of the last year/month. But if I use DATEADD or SAMEPERIOLASTYEAR to get the results of last month and last year. I will be comparing 7th o Junuary 2020 vs 31th of Junuary 2019 for mention an example. I need to always compare current days of the month vs the same days of last year/month. My table is grouping by Month. Could you share the link of the video?. I appreciate the help! Kind regards.

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

Is this one? m.ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--xBYtOVyMTs.html /Ruth

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

How can i filter THE weekends from this count?

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

I learned about EOMONTH at the beginning of a decade.

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

Dang ! Should Have published it EOMONTH of the decade, that would have been something ;) /Ruth

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

Great! Always have rouble with dates. Would be useful (specially for finance) if you could show a way to handle working days including national and local holidays. Best!

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

Leandro, I used to have that situation and I dealt with it by including a column in the date table with "Work Day" and 0 and 1, that way you can add (sumx) that column between the dates you want to analyze and get the work days.

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

@@rauljimenez5485 thanks I will try

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

@@leandrogalvao1132 , an additional thing that might be useful is: I had 2 columns for workdays, one for each country. In order to find out how long a process took, I did SUMX of (Col1 * Col2), that way it only added days in which both countries were working.

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

@@rauljimenez5485 clever, guess that building support columns is the way to go.thanks!