Measure or Power Query?

Hello! I have created 2 calculated columns: This column counts the number of rows QP Row Count = IF(COUNTROWS(RELATEDTABLE(QP))>0;COUNTROWS(RELATEDTABLE(QP)); 0) And this one makes the d...

Need Help

v-qiuyu-msft

Community Support

10 years ago

Hi gonrodrigues,

You mentioned "With calculated columns PBi doesn't allow me to create a relationship with Date table due to 'Circular dependency' error and without that i cannot use the proper filter from Date table.", do you mean you want to filter waterfall chart based on the value from Date table, right?

I have followed your steps to create two calculated columns and a waterfall chart, everything is fine. In your scenario, you need to check relationship among QP, Variação and Date tables. Please refer to screenshots below:

If you have any question, please feel free to ask.

Best Regards,
Qiuyun Yu