Forum Discussion
Roster Planning
Hi SoLoNOx , do you want something like this?
To achieve this, you need to transform the data in Power Query Editor first. Try below codes in Advanced Editor and you will get a new column Dates. Then put this Dates column in a matrix visual. Here is a PBIX file for reference.
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WilDSUTIyMDLUNdQ1QTAtgExnH1dHP08/d6VYnWilSIScJYJpaABkhzsGe8CURSHJWSDYRqZAdoCjp18IWGEsAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [People = _t, #"Start Date" = _t, #"End Date" = _t, Job = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"People", type text}, {"Start Date", type date}, {"End Date", type date}, {"Job", type text}}), #"Added Custom" = Table.AddColumn(#"Changed Type", "Dates", each List.Dates([Start Date], Duration.Days([End Date]-[Start Date])+1, #duration(1, 0, 0, 0))), #"Expanded Custom" = Table.ExpandListColumn(#"Added Custom", "Dates"), #"Changed Type1" = Table.TransformColumnTypes(#"Expanded Custom",{{"Dates", type date}}) in #"Changed Type1"Kindly let me know if this helps.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
SoLoNOx , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
refer if one of this can help
Hi amitchandak ,
Here is a sample of random data (Excel and its implementation on pbix)
You can see that activities are directly linked to the "first" date which is the Starting Date whereas I'd like to have the task (Cleaning) from the 4th to the 8th and not only showing for the 4th..
Thanks for your quick reaction though !!
Hi SoLoNOx , do you want something like this?
To achieve this, you need to transform the data in Power Query Editor first. Try below codes in Advanced Editor and you will get a new column Dates. Then put this Dates column in a matrix visual. Here is a PBIX file for reference.
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WilDSUTIyMDLUNdQ1QTAtgExnH1dHP08/d6VYnWilSIScJYJpaABkhzsGe8CURSHJWSDYRqZAdoCjp18IWGEsAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [People = _t, #"Start Date" = _t, #"End Date" = _t, Job = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"People", type text}, {"Start Date", type date}, {"End Date", type date}, {"Job", type text}}), #"Added Custom" = Table.AddColumn(#"Changed Type", "Dates", each List.Dates([Start Date], Duration.Days([End Date]-[Start Date])+1, #duration(1, 0, 0, 0))), #"Expanded Custom" = Table.ExpandListColumn(#"Added Custom", "Dates"), #"Changed Type1" = Table.TransformColumnTypes(#"Expanded Custom",{{"Dates", type date}}) in #"Changed Type1"Kindly let me know if this helps.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.Hi Jing Zhang,
Thanks for helping me out here.
Very much appreciated !!
Stay safe.
TL