Forum Discussion
Checking Data Completeness
Hi I am new to PowerBI/PowerQuery, the following task might be trivial to some of you, but your help is highly appreciated 😁. For example: I have three columns, where each column is presented f...
you can decide where to implement that check, in Power Query or in Power BI/DAX. Since the data is not impacted by user filters this means in DAX you would use a Calculated Column (not a measure)
The syntax is slightly different.
Power Query:
newstep = Table.AddColumn(previousstep,"Status", each if #"Masterfile A" = null or #"Masterfile B" = null then "Incomplete" else "Complete")
DAX:
Status = IF([Masterfile A]==BLANK() || [Masterfile B] == BLANK(),"Incomplete","Complete")