Download File ⬇ - goodly.co.in/how-create-project-overlapping-timeline-dashboard-power-bi

I really like your DAX routines to perform conditional formatting

The way of representation using this matrix, highlight selected row based on the slicer selection, overlapping concepts are very interesting and useful. Thank you Chandeep.

Thank You!!! This is great!!

Verry helpful, I used it on promotions that are overlapping.

So cool! I love your awesome videos, thank you so much!!! 👍🏻

Your videos are great! Thank you Chandeep!🙂

Always fantastic! 😀

Thank you Chandeep

very good, thanks.

Great video as always . thanks a lot . here is an other way to get the same result using dax only ( and withoud necessarily connecting calendar table to Data table ) Measure= VAR START_DATE_PROJECT=SELECTEDVALUE(Data[Start]) VAR END_DATE_PROJECT= SELECTEDVALUE(Data[End]) VAR CURRENT_DATE_MAX= MAX('Calendar'[Date]) VAR CURRENT_DATE_MIN= MIN('Calendar'[Date]) VAR _CONDITION = START_DATE_PROJECT= CURRENT_DATE_MIN return if(_CONDITION,"➖")

thank you very much. Suppose what if i have Project name, planned start date, planned end date, actual start date, actual endate. Now i need to show Planned vs Actual.

Very cool (of course!). Is this even possible in Excel? Would love to see that.

Thank you very much. I really need this slicer trick for my personal project.

@GoodlyChandeep

11 ай бұрын

Glad it was helpful :)

1:57 what’s the last line of code for the If statement ?

I am currently in a journey of becoming a power Bi developer and it's been a year I have explored right from Power query to Bi service. Need your inputs on how much level of understanding needed on M language and Dax for a fresher. Especially in current market situation.

@GoodlyChandeep

11 ай бұрын

Keep it simple, Praveen! Understand the concepts and keep learning. There's no set number. Learn as much as you're interested in. Good luck on your Power BI journey!

@praveenkumar_0143

11 ай бұрын

@@GoodlyChandeep Thank you so much!! 😊😊

Hi.. I am working on a project related to creating Calendar table . I am watching your video s but I am stuck at certain points. I need to join your channel so that I can ask the queries. Is there any way to connect ?

Kindly share the dax details for measure of start project and end project

@GoodlyChandeep

10 ай бұрын

goodly.co.in/how-create-project-overlapping-timeline-dashboard-power-bi

🤟

Does your Power Query course cover the fundamentals, and code development at the level we took a glance at on this video? Thanks for sharing!!

@GoodlyChandeep

10 ай бұрын

The current Power Query course is mostly exploring and solving the problems using the UI. A new M Language course is going to be out by next month end (which will cover things way beyond this video's complexity). Hope that helps

It is a very good solution, but when you work with millions of records it stops working and the performance is not good. For these cases what would you recommend?

@snackymcgoo1539

10 ай бұрын

I would say figure out a way to change this from dynamic ram, and perform a cross join upstream in TSQL to achieve same result. Unfortunately the load of the additional records will take longer, but the dashboard would perform better. Actually, I don't know, the list approach here is the same as a cross join in tsql, performance would be bad either way. I have encountered this in other applications of cross join, not for this purpose in the video but other purposes.

Why bother generating dates in between?? That is waste of space. Just drop the relation to calendar and do the checks for staring and ending dates against min and max dates. For overlap it's even easier. Wrap project in ALL and then do same checks for dates against slicer selection (additional table based on mian project db). Multiply results by earlier check to make second valid when first one returns 1. Third step is highlighting project that was selected on slicer. Again easy, just compare selected values from two tables and again multiply it by first check. Confused, write back and I will send sample.

Mi chiedo invece perché devi fare una masterclass se hai già delle rendite così remunerative.