Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hello everyone.
I'm creating a report for visualizing tasks from a project. I need a table with the name of the tasks, start and end dates, etc.
Problem is, part of the columns got Dates in their names, and the rows must show the % of advance to that task on that date. Thoose dates are a period selected by the user.
Something like that, but in Power BI.
Where the predicted % progress must be calculated based on business days between the start and end dates, so, if the task has 3 days of duration, it needs to be 33,33% each day (if theres no weekend and holidays between these 3 days). In that case, the image would show 100% for all dates of the period, since the period is always from seven to seven days.
In other words, I need to calculate the % based on the columns start and end dates, and then show it for each day of the selected period, wich must be presented in the columns.
My first try was creating a slicer so the user can filter the dates, and the columns must change based on the filter, like if the user filters 01/04/2023 as start date from the period, the columns must be like the imagem and show the values of %. Dates always needs to be minimum date filtered in the slicer + 7, + 14, + 21 and + 28. I tried doing that but I coulnd't.
I also tried doing this in PowerQuery, my idea was to save the name of the file with the start date of the period, so I can use it to do all the calculus and then just show it's results, without the slicer. But, I failed too.
Note that the % only depends from start and end date, but the user must see its advance on the period that he chooses.
The database is imported from MS Project.
I know that is not usual to show dates in columns names, but the user asked to be like this.
Is there a way to doint that? Or there's a better way to showing that information?
Read about NETWORKDAYS()
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523