Forum Discussion

v-caliao-msft's avatar
v-caliao-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Anonymous,

 

Based on my understand, I don't think it will be easy to achieve this in Power BI. You'd better to do it on your data source. You can cleaning your data before loading into data warehouse. And then use this data warehousr as the data source of your Power BI report.

 

Regards,

Charlie Liao

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Thanks v-caliao-msft for your reply.

 

Yes, doing it in the DataWareHouse whas one of my options. In fact, many business rules are solved there. The problem is that some rules are only for visualization in a specific scenario. Example, when having a monthly meeting for showing the months sales.

 

Thanks!