Hi P Horton, Glad that this video is of help! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!
Hi Haroon (and eDNA team)! Thanks for sharing these challenges. Dealing with real life scenarios is very instructive. Regarding the Duration calculation, I think "[End Date] - [Start Date]" makes you miss one day leading to wrong daily calculations. Which, depending on how you deal with the daily information can give wrong quarterly / yearly totals. I tried to post this on the forum but, as I didn't enroll, couldn't access.
Hello Sami ELZAIM, thank you for posting your query onto our channel as well as for participating into our "Problem Of the Week" challenges. We're providing a link below of the post of the challenges created for the fourth week and you can review the solution provided by the other participants as well for better understanding. Hoping you find this useful. Happy Learning!!! forum.enterprisedna.co/t/problem-of-the-week-4-pq-addressing-granularity-issues/13586/32
Hello Sagenose, thank you for posting your query onto our channel. Well once the data is broke out into the day granularity than you can substitute the Date from day level granularity to the month level granularity. You'll just be required to replace the day field with the month field into the visualization. We're providing the link of the date table which is available onto our Community Forum which will help in this case. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful and meets your requirements. Happy Learning!!! forum.enterprisedna.co/t/extended-date-table-power-query-m-function/6390/75 forum.enterprisedna.co/
![PASULOL รามเกียรติ์ ตอนที่ 4 นนทกพบรัก [Ramakien Ep.4: Nonthok in love]](http://i.ytimg.com/vi/tMUQgmZzf_A/mqdefault.jpg)
Brilliant! This is going straight into the PBi toolbox. Thank you
Hi P Horton, Glad that this video is of help! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!
That’s badass, to put it simply. You have earned a subscriber.
Hi Haroon, amazing solution! thank you so much... Is there a way to avoid weekends, saturdays and sundays, in the list of dates to create ??
Also, as Sami stated below, you do have to add one to the Duration column, or your monthly totals will not add up correctly.
Correct, the duration will be a day short, for example, duration of 1st April - 1st May will equate to 30 days as you are taking 44287 from 44317 👍
Hi Haroon (and eDNA team)!
Thanks for sharing these challenges. Dealing with real life scenarios is very instructive.
Regarding the Duration calculation, I think "[End Date] - [Start Date]" makes you miss one day leading to wrong daily calculations.
Which, depending on how you deal with the daily information can give wrong quarterly / yearly totals.
I tried to post this on the forum but, as I didn't enroll, couldn't access.
Hello Sami ELZAIM,
thank you for posting your query onto our channel as well as for participating into our "Problem Of the Week" challenges.
We're providing a link below of the post of the challenges created for the fourth week and you can review the solution provided by the other participants as well for better understanding.
Hoping you find this useful.
Happy Learning!!!
forum.enterprisedna.co/t/problem-of-the-week-4-pq-addressing-granularity-issues/13586/32
Haroon, how would you break out the {start..end} into months rather than days?
Hello Sagenose,
thank you for posting your query onto our channel.
Well once the data is broke out into the day granularity than you can substitute the Date from day level granularity to the month level granularity. You'll just be required to replace the day field with the month field into the visualization. We're providing the link of the date table which is available onto our Community Forum which will help in this case.
For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well.
Hoping you find this useful and meets your requirements.
Happy Learning!!!
forum.enterprisedna.co/t/extended-date-table-power-query-m-function/6390/75
forum.enterprisedna.co/