Forum Discussion
automate and exclude certain values with excel
Hello community,
Im new to Power BI and i've made a dashboard connect to folder to auto update with excel files.
This part is working fine the problem is that the excel file always has 3 months.
For example the report from January has the last week of December and the first week February and the report of February has the last week of January and the first week of March, and so on..
When i import the February report it changes the value of January because the excel file has the last week of January.
Is there anyway to correct this on power bi without removing directly on the excel file?
Tkx in advance
2 Replies
Yes, but I'm not going to guess on how your data is layed out x0cks. Please provide some sample data per the links below.
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.Hi x0cks ,
Sounds like duplicated date values in columns. Please try to remove depulicated columns each time you update your folder and check it again.
In addition, you can consider sharing some sample data and expected output for further discussion.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
