Power Query

[Anonymous]

Below is the Input

Below is the Output

Would this even be possible using Power Query?

[v-zhangti · Accepted solution]

Hi, @Anonymous 

In the matrix view of Desktop, you can output the results you expect.

Column:

End Date = [Start Date]+[Days Booked]

Create a new date table.

Date = CALENDAR(MIN('Table'[Start Date]),MAX('Table'[End Date]))

Column:

Weekday = FORMAT([Date],"dddd")

Measure = 
IF (
    SELECTEDVALUE ( 'Date'[Weekday] ) = "Saturday",
    BLANK(),
    IF (
        SELECTEDVALUE ( 'Date'[Weekday] ) = "Sunday",
        BLANK(),
        CALCULATE (
            MAX ( 'Table'[Project Name] ),
            FILTER (
                ALL ( 'Table' ),
                [Start Date] <= SELECTEDVALUE ( 'Date'[Date] )
                    && [End Date] >= SELECTEDVALUE ( 'Date'[Date] )
                    && [Staff Name] = SELECTEDVALUE ( 'Table'[Staff Name] )
            )
        )
    )
)

Measure:

Color = SWITCH(TRUE(),
SELECTEDVALUE('Table'[Project Name])="ABC Pte Ltd","Yellow",
SELECTEDVALUE('Table'[Project Name])="DEF Pte Ltd","light gray",
SELECTEDVALUE('Table'[Project Name])="GHI Pte Ltd","blue",
SELECTEDVALUE('Table'[Project Name])="JKL Pte Ltd","gray")

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks so much!

[ddpl]

@Anonymous 

You should try Gantt Chart, which you will get in Power BI in Get more visuals Section.