Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
For any DateTime that exists in both, it is fine and the line graph shows both values, but for any DateTime, that a row exists for one and not the other, it will only show the one. Since this is an aggregation of totals, the total should still be the same as the prior available DateTime value.
10/17 only exists for one, so only shows the one, but the value of CDTotals that was last valid should show instead. The DAX I am using for the measures is as follows:
Hi @jburbano,
are you using a date table?
Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
Yes, I am:
let
Source = Table.Combine({Table.SelectColumns(Releases, {"release.createdOn"}), Table.SelectColumns(Builds, {"build.queueTime"})}),
#"Merged Columns" = Table.CombineColumns(Table.TransformColumnTypes(Source, {{"release.createdOn", type text}, {"build.queueTime", type text}}, "en-US"),{"release.createdOn", "build.queueTime"},Combiner.CombineTextByDelimiter("", QuoteStyle.None),"DateTimes"),
#"Changed Type" = Table.TransformColumnTypes(#"Merged Columns",{{"DateTimes", type datetime}}),
#"Extracted Date" = Table.TransformColumns(#"Changed Type",{{"DateTimes", DateTime.Date, type date}}),
#"Removed Duplicates" = Table.Distinct(#"Extracted Date"),
#"Sorted Rows" = Table.Sort(#"Removed Duplicates",{{"DateTimes", Order.Ascending}}),
#"DateTimesList" = List.Dates(
Record.Field(Table.Min(#"Sorted Rows", "DateTimes"), "DateTimes"),
Duration.Days(
Record.Field(Table.Max(#"Sorted Rows", "DateTimes"), "DateTimes")-Record.Field(Table.Min(#"Sorted Rows", "DateTimes"), "DateTimes")
),
#duration(1, 0, 0, 0)
),
#"Converted to Table" = Table.FromList(DateTimesList, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Changed Type1" = Table.TransformColumnTypes(#"Converted to Table",{{"Column1", type date}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type1",{{"Column1", "DateTimes"}})
in
#"Renamed Columns"
This gives me a tables of dates from the MIN date of either Builds or Releases and then find the count by subtracting the MIN date of CI or CD from MAX date and set the step to days.
Would it be a matter of combining tables by the Dates column?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
144 | |
73 | |
64 | |
52 | |
51 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |