Forum Discussion

siddhantk989's avatar
siddhantk989
Helper III
9 years ago
Solved

Calculated Column is returning blank values

Hi,     I am trying to create a table to show my forecast data. the forecast data is based on category and i have Target % to calcualte the forecast. Sales column is a measure which i am calulating...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • siddhantk989's avatar
    siddhantk989
    9 years ago

    MFelix and Anonymous 

     

    Found the soultion. I did all the calculation in SQL and then I am bringing my data to Power BI. It is working fine now.

     

    Thanks  alot for supporting guys.

     

    You guys are great.

     

    Thanks,

    siddhant

  • siddhantk989's avatar
    siddhantk989
    9 years ago

    v-huizhn-msft,

     

      It is kind of a temporary solution as I did nothing in Power Bi to resolve it. What I am doing is that instead of creating calculated fields in Power BI I am creating those column in my database itself while fetching the data.

siddhantk989's avatar
siddhantk989
Helper III
9 years ago

MFelix and Anonymous 

 

Found the soultion. I did all the calculation in SQL and then I am bringing my data to Power BI. It is working fine now.

 

Thanks  alot for supporting guys.

 

You guys are great.

 

Thanks,

siddhant

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi siddhantk989,

Glad to hear you have resoled your issue by yourself, please mark coresponding reply as answer. So that more people will benefit from it, and find workaround easily.

Best Regards,
Angelia

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi siddhantk989,

    Great job. Please mark your solution as workaround, so that more people will benefit from here.

    Thanks,
    Angelia

  • siddhantk989's avatar
    siddhantk989
    Helper III
    9 years ago

    v-huizhn-msft,

     

      It is kind of a temporary solution as I did nothing in Power Bi to resolve it. What I am doing is that instead of creating calculated fields in Power BI I am creating those column in my database itself while fetching the data.