Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

NULL Value in DAX statement

Hi, I would like to add null values to the results_table below. Could anyone please advise me how to do that? Results_Table = SELECTCOLUMNS( GENERATE( 'Table1'; FILTER( 'Table2'; 'Table1'...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

     

    I don't think so. For example, there will be a seminar name [Seminar Name] from table 1 with no value for opportunity from table 2, "OpportunityName";Table2[name]. I would like to see these rows where OpportunityName has blank values but presently I don't.

     

    Thanks

    • v-chuncz-msft's avatar
      v-chuncz-msft
      Community Support
      6 years ago

      Anonymous 

       

      Just use GENERATEALL instead.