Forum Discussion

StuartSmith's avatar
StuartSmith
Power Participant
5 years ago

Filter columns if all rows contain data

I am creating a report to show all records that have missing data, so that the dataset owner can update the missing data.   I currently have a table that shows rows that have missing data and as a ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi StuartSmith,

In fact, dax formula not suitable for these options. If statement also not able to handle table-level results, I'd like to suggest you refer to AlB suggestion to use power query functions to do achieve your requirement.

Regards,

Xiaoxin Sheng

StuartSmith's avatar
StuartSmith
Power Participant
5 years ago

Sorry, I thought I replied to this thread.  I tried the solution by "CNENFRNL", but found that it didnt hide the columns dynmically.  What I mean by this, is that when the created the power query solution, it hide any columns that already had data in every row, but if I updated the data source and then refreshed the data, any new columns that had all row completed were still visible and were not removed.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi StuartSmith,

    In fact, power query table structure will be cached in query steps and they weren't dynamic changes if the result changes.  You need to manually manage these structures and fix them in the following steps if the raw calculation results changed.
    Regards,

    Xiaoxin Sheng

    • StuartSmith's avatar
      StuartSmith
      Power Participant
      5 years ago

      Thanks, I will just tell the user that its currently not possible.