Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Data validation against different datasets

Good day!   I have been developing a revit model health dashboard in Power BI, and for my first version of the work I did all of the calculations in excel (see the link below) and loaded the polish...
General Comment
Need Help
Tips and Tricks
TeigeGao's avatar
TeigeGao
Solution Sage
7 years ago

Hi Anonymous ,

I would suggest you explain your requirement with your sample data and share the expected result to us for analysis. I think I can't understand your requirement very well.

>>Evaluate each cell with "0" if the cell contains "-", "N/A", "TBC", or is blank, otherwise it is "1".

This requirement is easy, we can do that in Power Query, in power query, we can add a conditional column like below:

Best Regards,

Teige

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Teige,

 

I get that there is a calculated column for that. I meant to do the checking for all columns in the raw data. So, in the screenshot below there are cells that are populated with "-" and blanks. These cells should be evaluated with a "0" in a new table as well as cells with "N/A" or "TBC" in it instead of the appropriate data, otherwise the cells should be evaluated with a "1".

 

I hope this helps.