Replacing with 0 if value not exist

[hareesh3621]

Name	Date	Value
A	Jan 1st	60%
B	Jan 1st	70%

I have two tables like this. Im trying to show trending of % in different dates.

Name	Date	Value
A	Jan 30	65%
B	Jan 30	60%
C	Jan 30	70%

Name “C” doesn’t exist in previous table. In trending its not showing it as 0. Instead its showing C only on Jan 30th. I wanted something like if value doesn’t exist take it as 0. How can I show that on Line chart.

[v-qiuyu-msft · Accepted solution]

Hi @hareesh3621,

In your scenario, you can merge table 1 with table 2 to ensure table 1 has row for C as well. Then append the new table 1 with table 2. For Detail information, you can download attached pbix file, then go to Query Editor. 

Best Regards,
Qiuyun Yu