Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Ramon_Mac
Frequent Visitor

Dates in column names and predicted % progress

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.

Ramon_Mac_2-1680536927623.png

 

 

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?

1 REPLY 1
lbendlin
Super User
Super User

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.