Clever Date Table Trick in Power BI you've got learn!

[@GoodlyChandeep]

⬇Download the file used in the video - goodly.co.in/neat-calendar-table-trick-power-bi

[@WaymondJr]

Your videos are gold! Thank you for all your efforts, I learn every time I watch!❤

[@syrophenikan]

FANTASTIC!!! I'll be implementing this ASAP!!!

[@textnotepro]

I got here by searching for a solution to this problem - this video is fantastic, so clearly explained with great examples. Thank you. I have subscribed.

[@Nalaka-Wanniarachchi]

Nice one Chandeep !! W/O Calc column using measure ; MEASURE 'My Measures'[Sales YTD2] = TOTALYTD([Total Sales],'Calendar'[Date], FILTER( all('Calendar'), 'Calendar'[Date]

[@gezin_longuevilleosaer4245]

You make my day, again. Thanks!!

[@GoodlyChandeep]

Glad to hear that :)

[@azwarmzafar]

Thank you, that was an amazing trick and eye opener video.

[@gennarocimmino]

Thank you Chandeep, better and better

[@chrism9037]

Very clever, thanks Chandeep!

[@GoodlyChandeep]

Thanks again Chris :)

[@unnikrishnansanthosh]

another class one, thank you for sharing

[@williamarthur4801]

Thanks, I've always just use a if total sales Blank etc. , but this is much neater also regarding the use of nested CALCULATE that is something that I never really know if it's needed.

[@GoodlyChandeep]

Total Sales Blank can also be false in a month or week in between the data. What we really need is display until the end of the last sales date.

[@joselencinamalgor6548]

Brilliant!

[@Bhavik_Khatri]

Nice technique.

[@juanocasio8998]

Thank you for all of the content you provide. For those of you who have not purchased Chandeep's courses, I totally recommend them. Chandeep: I am thinking about purchasing the Mastering DAX in Power BI course. What's the difference between that and Mastering DAX and Data Modeling (which I already purchased)?

[@GoodlyChandeep]

You have the new one.. don't buy the old one.

[@skv4611]

Hi Chandeep, Can't we just create a measure using isempty func with not and apply as filter

[@rajendracheraku1]

Super Brother

[@gennarocimmino]

Dear chandeep, In this video, you proposed as a solution the addition of a calculated column in the date table. It would be interesting to have a video, a version 2 of the proposed solution, with a DAX measure, perhaps with a virtual calendar table and with the addition of a calculated column, but in the virtual table, variable of a DAX measure. Greetings

[@deeswift-z1h]

Hi It looks out of the context but I wanted to know if is it possible that can we 've Month on month %change of count even if we just have one month data and next month data is yet to get updated ?

[@SSRealEstates83]

Will the months change dynamically?? When i used 0 i was getting all trues so i tried with -2 then my data got matched,when i move from july to August month will this measure work dynamically?? Thank you

[@tubephvalue]

How would you do this in Excel Power Query?

[@justapasserby69420]

Why not just create a calendar table using MIN and MAX dates of the fact as the date range to avoid this problem altogether?

[@GoodlyChandeep]

Possible if you have only a single date column in the sales table. Imagine a sales table with 3 date columns : Sales Date, Delivery Date, Refund Date (if refunded), in those cases you're somehow forced to make a longer calendar table than the last date of sales date.

[@dimmitrio]

Imagine that you have table with plan data that is set in future dates. And you need to track plan and fact. So you need approach from video.

[@RayyanAziz-ku2rc]

for the same problem, once you used a nested calculate, and the other time you did not. This is quite confusing.

[@RamonTomzer]

Calculate wrapped in a calculate?! Greg Deckler would not approve of this 😂

[@МихайлоСтерлігов]

Hi. What wrong with Calculate( totalYTD(...) , NOT ISempty(Sales[date]) )

[@user-yh8wp2ic6o]

Why not create a few variables and wrap it in a RETURN IF( X ), BLANK() ) ?

[@mienzillaz]

Normally I love your content, especially about PQ but.. this one is just really bad.. Avoid calculated columns people whenever you can and put that check in YTD measure itself.. EZ to pull, and if someone want to know how leave a comment below mine..

[@djl8710]

Whole day calculated columns are NOTHING for performance, on the other hand billions of fractions of time are a problem like you say.

[@GoodlyChandeep]

I don't out rightly discard calculated columns, especially if they simplify logic and improve performance. The use of calculated columns is very selective case by case.