If 1 ID has a blank show blank for all other records with the same ID

[Isildur__]

Hi Guys,

Essentially what I'm trying to do is create a calculated column that returns blank against ID's that have a blank in any other row with the same ID.

The data lets say is like this

ID	Date
10	01-02-2023
10	01-02-2023
10
11	01-02-2023
11	01-02-2023

The final view should look like this. Because ID = 11 has no blank dates we can consider that populated. ID = 10 has one blank therefore we want to show that as not populated.

ID	Date	Check
10	01-02-2023	Not all populated
10	01-02-2023	Not all populated
10		Not all populated
11	01-02-2023	Populated
11	01-02-2023	Populated

What area of DAX does this specifically apply to. Really want to get better at row level comparisons based on previous months, earlier records etc.

[lbendlin]

No need for DAX

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjRQ0lEyMNQ1MNI1MjAyVorVwSOmAGEaYpFGF4sFAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ID = _t, Date = _t]),
    #"Grouped Rows" = Table.Group(Source, {"ID"}, {{"Rows", each _, type table [ID=nullable text, Date=nullable text]}, {"Check", each List.Min([Date]), type nullable text}}),
    #"Expanded Rows" = Table.ExpandTableColumn(#"Grouped Rows", "Rows", {"Date"}, {"Date"}),
    #"Replaced Value" = Table.ReplaceValue(#"Expanded Rows",each [Check], each if [Check]=" " then "Not All Populated" else "All Populated",Replacer.ReplaceText,{"Check"})
in
    #"Replaced Value"

How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done".