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.