Forum Discussion
Data Cleaning
I need to scrub data from a report that contains a summary of the current month and summary of Life to date. My report has several breaks in it and the headers for the current month and the Life to date section are the same. Is it possible to remove all data after the Life to date text in my report so I only have the current month data?
Thank you in advance.
1 Reply
Hi LiG ,
I'm getting less information from the above.
If these are visuals and you don't want to show them to your customers, is it possible to check these visuals and remove or hide them?
If you want to load only the current month's data into the model. Try adding a custom column use Date.IsInCurrentMonth() in powerquery.
Date.IsInCurrentMonth - PowerQuery M | Microsoft Learn
Then filter.Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
