Forum Discussion
Need help to exclude data
- 6 years ago
I'd suggest adding a column to your table such as this, then filter your chart to "Yes":
DisplayOnlyValidPeriods = IF(Table1[Date Difference] <= (2019 - Table1[Account Open Year]) * 12 + 5, "Yes", "No" )Presumably, this is a data set that will be occasionally updated. As such, you'll probably want to update the hard-coded 2019... logic to something that uses the current year/month minus whatever lag you want to include in the reporting.
- 6 years ago
CoalesceIsMore Thank you so much for your answer. I have managed to get the desired result by using your calculated column but I have amended a little:
DisplayOnlyValidPeriods = IF('Main Query'[z. Date Difference From Account Open to Month] <= (Year(Max('Main Query'[Month_Start_Date]))-1 - 'Main Query'[Account_Open_Date - Year Only]) * 12 + 'Main Query'[Max month], "Yes", "No" )now I am planning to add a calculated table which will only store max month from my date.
Thanks for all the help.
If I was in this scenario I'd probably try and apply those rules to my data source rather than in the report. I've made assumptions that the data is stored in a database and the additional data isn't used somewhere else within your report.
- adnanarain6 years agoHelper V
Thank you PaulJ71 for the reply. My data stored in excel file and i am using that data in other visuals so i can not exclude data from my data source. I only want to apply this condition in this visual only.
- v-lionel-msft6 years agoCommunity Support
Hi adnanarain ,
Please show a sample data model.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- adnanarain6 years agoHelper V
Thanks for the reply, I will upload soon.