Forum Discussion

gonrodrigues's avatar
gonrodrigues
Helper III
10 years ago

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's avatar
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

 

 

 

 

 

 

 

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Community Support
      10 years ago

      Hi gonrodrigues,

       

      In your original post, you mentioned you create two calculated columns: [QP Row Count] and [Difference From Prior Month] in table Variação, then you need to create a membership between Variação and QP tables instead of Variação and Data tables.

       

      If issue persists, please share .pbix file for our analysis if possible.

       

      Best Regards,
      Qiuyun Yu

      • gonrodrigues's avatar
        gonrodrigues
        Helper III
        10 years ago

        hey v-qiuyu-msft

         

        Said I needed to create a membership between variação and Data tables :)

        Unfortunately, I cannot share .pbix file, it has confidential info

  • gonrodrigues's avatar
    gonrodrigues
    Helper III
    10 years ago

    v-qiuyu-msft

     

    Can you help me doing these 2 columns in power query?Probably work this way :)