Forum Discussion

mikep7521's avatar
mikep7521
Icon for Helper III rankHelper III
8 years ago

Power BI Data Shaping

Hello,   I'm havnig an issue creating a metric in Power Bi. Im trying to capture when two fields are blank and the Est. Close date was in 2017. I tried to accomplish this by creating a new column, ...
mikep7521's avatar
mikep7521
Icon for Helper III rankHelper III
8 years ago

Hello,

 

I have tried posting the sample data and expected result but it keeps getting flagged as spam and is removed from the feed for some reason.

I'm now recieving the below error using the formula you suggested:

The column 'Installment[Est_Close_Date__c].[Date]' either doesn't exist or doesn't have a relationship to any table available in the current context.

There is a field for Est. Close Date but not a column. Do I need to create a column?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

What do you mean by field? The assumption is all elements you have used in the formula's are existing as columns in your table.

 

Thanks

Raj

 

  • mikep7521's avatar
    mikep7521
    Icon for Helper III rankHelper III
    8 years ago

    As in a Salesforce field. I'm pulling my data from a Salesforce org.