Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Group by / Summarize with 'incomplete' data?

Hi Power BI Community,   I've got an interesting problem that perhaps you can shed some light on.   Please consider the below two tables:   DocumentID Document 1 DocA 2 DocB 3 D...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try a new table

    ADDCOLUMNS(crossjoin(person, selectcolumns(document,"ID",[document ID],"Document",[Document])), "Date_Added new", if([ID] = [document ID], [Date_Added], blank()))

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Try a new table

ADDCOLUMNS(crossjoin(person, selectcolumns(document,"ID",[document ID],"Document",[Document])), "Date_Added new", if([ID] = [document ID], [Date_Added], blank()))