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.
Hello,
I am looking for a project, according to a number of months between 2 dates, resources in a matrix (see illustration)
I thought about doing either doing a benchmark query to build the projection, but maybe there is a DAX solution that would be faster for volume management ?
Do you have any leads?
Thank you
Solved! Go to Solution.
Like this for example:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUTLWN9c3MjAyBDINDfSNDWEcAz0QaaQUqxOt5ARkmembwNUZ6hsbwDhGIDOUYmMB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Projet = _t, #"Date prévi début" = _t, #"Date prévi fin" = _t, Direction = _t, #"Chef de projet" = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Date prévi début", type date}, {"Date prévi fin", type date}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Date", each List.Dates([Date prévi début],1+Duration.Days([Date prévi fin]-[Date prévi début]),#duration(1,0,0,0))),
#"Expanded Date" = Table.ExpandListColumn(#"Added Custom", "Date")
in
#"Expanded Date"
"Total" is a measure
Like this for example:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUTLWN9c3MjAyBDINDfSNDWEcAz0QaaQUqxOt5ARkmembwNUZ6hsbwDhGIDOUYmMB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Projet = _t, #"Date prévi début" = _t, #"Date prévi fin" = _t, Direction = _t, #"Chef de projet" = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Date prévi début", type date}, {"Date prévi fin", type date}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Date", each List.Dates([Date prévi début],1+Duration.Days([Date prévi fin]-[Date prévi début]),#duration(1,0,0,0))),
#"Expanded Date" = Table.ExpandListColumn(#"Added Custom", "Date")
in
#"Expanded Date"
"Total" is a measure
many thanks 👌 👏
Not sure what this has to do with time intelligence, but in a matrix visual you can choose to show your measures "on rows" to achieve the desired visual output.
Thank you
but how to go from the 1st table to the 2nd table?
With powerQuery?
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.