Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Below is the Input
Below is the Output
Would this even be possible using Power Query?
Solved! Go to 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.
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.
Thanks so much!
@Anonymous
You should try Gantt Chart, which you will get in Power BI in Get more visuals Section.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |