Data validation?

[swebb]

I don't know if I'm using the correct terminology for this, but I'll give an example. I have 3 conditional columns that provide a value based on the value of another column. However, the end user has made it known that if one condition fails, then they should all resort to a certain value.

E.g.,:

Quoted Price for SaaS, Quoted Price for Service, then a total of the two; if Quoted not null or 0, use Quoted. If Quote is null, use Estimated, then add Total. However, if Quoted and Estimated are both used, use Quoted, ignore Estimated. 

This is data coming from CRM. Not sure if Power BI is the best place to validate this or if CRM is best place to validate. Thoughts? 

[PhilipTreacy]

Hi @swebb 

This sounds possible but I'm confused by the description, for example if Quoted not null or 0, use Quoted which Quoted column are you referring to?

It would be easier to offer a solution if you provided some sample data so I can see the table structure.

Regards

Phil

[swebb]

So, here's an example of what should happen:

Essentially if both quoted and estimated are used, only use one or the other, in all cases, the actual quoted should be used, not estimated. If all amounts are estimated amounts, use those, if all are quoted, used quoted, if a mix, use only quoted.