DAX Fridays!

[@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!

[@AliAbbas-ik9ix]

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

[@srikrishnasoftskills1179]

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])

[@esakaakkurivaara1793]

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]

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

[@esakaakkurivaara1793]

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

[@ayobamiologun9184]

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

[@CurbalEN]

Thanks Ayobami! /Ruth

[@klandestin83]

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

[@uzairrasheed3495]

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

[@stesteq2838]

How can i filter THE weekends from this count?

[@harisankar8939]

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

[@harisankar8939]

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

[@marlonmunozguevara7778]

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]

Is this one? m.kzbin.info/www/bejne/Y6mliqeFi96AitU /Ruth

[@jochendecraene5519]

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]

Noted for a future video :) /Ruth

[@jochendecraene5519]

@@CurbalEN That would be so great! Thanks

[@srinivasreddyg8441]

Can we call Parameters in Fax functions? If yes could you please let me know how to use with examples

[@CurbalEN]

Yes, you can and sure, I can do a video on it ! /Ruth

[@praveenkakumanu919]

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.

[@oKUNDURUVYSHNAVI]

May I know what is 18 I mean years or month

[@dabbileifs]

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

[@CurbalEN]

Grannar!! Vad kul :)

[@ommm4169]

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

[@CurbalEN]

Delighted to hear :)

[@jakeduddy3257]

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

[@CurbalEN]

Thanks for sharing Jake! /Ruth

[@harshadnizam7933]

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)

[@leandrogalvao1132]

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]

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]

@@rauljimenez5485 thanks I will try

[@rauljimenez5485]

@@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]

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

[@mchandrasekhar05]

Thanks Ruth! Really helpful:)

[@CurbalEN]

🎉🎉 /Ruth

[@richardtorrenueva5512]

Thank you... you resolve mine

[@jadrubiales]

Thanks Ruth Very interesting and usefull.

[@CurbalEN]

Great! /Ruth

[@Phoenixspin]

I learned about EOMONTH at the beginning of a decade.

[@CurbalEN]

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

[@nabaization]

how to get only the working days

[@oKUNDURUVYSHNAVI]

You can use networkdays function

[@vida1719]

Really little cool function!

[@CurbalEN]

Thanks Vida? /Ruth

[@ashokreddy9065]

day(max(date)) is enough