Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Calculation Error in power BI

HI,

 

Can anyboday help me out to calculate % Gap in data.

 

I am sharing screenshot of  sample dataset and also "Expected Answer" column in data.

I have also shared formula used to calculate this column.

 

Below is the screenshot of the data.

 

 

 

Thanks In Advance,

Rahul M

Data Modeling

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi,

       

      thanks for reply.

       

      I have tried this already but didint work actually..

       

      I have got solution for it instead of calculted column i used calculated measure for it and it works fine now.

       

      Again thanks for it.

       

      Regards,

      Rahul M

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

        Hi Anonymous,

         

        Glad to hear the issue is fixed now. It would be better if you could share the measure which will benefit other communities who have the same issue. 

         

        Best Regards,
        Qiuyun Yu