cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ramkijolla Frequent Visitor
Frequent Visitor

Re: left outer join using dax, Multiple to Multiple

Hi

I need to replace null\blank values from generateall ( null values from the Right Table ( Table2)) with 0 ( Zero).

 

Column1 ( from right Table) is whole number.

I have tried 

Column1+ 0

IF(isblank(Table2[Column1],0, Table2[Column1])

But it is still showing  Empty string\Blank Values.

 

Also, no calculations working on this Blank\Empty string. like Addition, subtraction,comparision on Blank Values. Calculation working if it has some values.

Could you please suggest solution?

ramkijolla Frequent Visitor
Frequent Visitor

Re: left outer join using dax, Multiple to Multiple

Hi @OwenAuger 

I need to replace null\blank values from generateall ( null values from the Right Table ( Table2)) with 0 ( Zero).

 

Column1 ( from right Table) is whole number.

I have tried 

Column1+ 0

IF(isblank(Table2[Column1],0, Table2[Column1])

But it is still showing  Empty string\Blank Values.

 

Also, no calculations working on this Blank\Empty string. like Addition, subtraction,comparision on Blank Values. Calculation working if it has some values.

Could you please suggest solution?

ramkijolla Frequent Visitor
Frequent Visitor

Re: left outer join using dax, Multiple to Multiple

This has been solved by keeping the results into Selectedcolumns or storing in physical table( This Null values has been modified as blank() values)

Highlighted
ramkijolla Frequent Visitor
Frequent Visitor

Re: left outer join using dax, Multiple to Multiple

Hi @OwenAuger ,

Can Table2 be Variable like Table 1. I have defined Table 1 and table 2 are defined in the same DAX window but Generateall is not working but it is working If one of the table is a physical table.

Could you please provide a sample with being Table 1 an dTable are declared as variables.

SamOPEN Frequent Visitor
Frequent Visitor

Re: left outer join using dax, Multiple to Multiple

Thx @OwenAuger, that helped me a lot !

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors