Forum Discussion
Need Help displaying duration based on 2 values
i want to thank you both for your help so far.
When i searched the internet for possible solutions i came across this custom visual
Gantt Chart By MAQ Software
And that is exactly what i need to fix the problem because i have a start date and sometimes an enddate and this visual displays it beautifully see the picture below
Refer my blog how deal with two dates (start and end)
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin
amitchandak that kinda helped but didn't solve my problem (yet)
The idea is pretty much the same but still some formulas don't work or don't provide the desired outcome
In your example the formula's are based on a value in the first or the second column (start date or end date)
My question is more displaying the duration of a certain permit and seeing when a permit is about to expire given i only have a start and enddate.
datediff can you duration and if you use end date relation then you can tell permits expiring in a month.
Can you share better sample data and sample output. If possible please share a sample pbix file after removing sensitive information.Thanks.
My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970Here you can see some sample data
The type of permit is in column 'Soort vergunning' and 'Datum aangevraagd' is the date on which the permit has been requested and the column 'Datum verleend' is the column on which date the permit has been approved.
The column 'Vergunning geldig tot' is the date on which the permit expires
this visual isn't correct (i know) but what i want is that the Y-axis has the types of permits and the X-axis has the dates/weeks (start/end/duration) so that i can visualise the duration of the permits