Future data restriction for Line Graphs

[Anonymous]

Hi Experts,

This question might have asked in the forum in the past but need to clarify this.

when we design line graphs with date column involved, how to we restrict the data to a certain period like to date , current weekend or month?

Date table consist upto date ranging to 2020 which i do not want display in the graph. When we create the dates based on the data table it will give upto the current date but how can I utilise the date table to solve this? 

Thank you.

Regards

[jdbuchanan71 · Accepted solution]

Hello @Anonymous 

If I am understanding the problem you are having, the folks at SQLBI have a good post about how to handle it.

https://www.sqlbi.com/articles/hiding-future-dates-for-calculations-in-dax/

[Anonymous]

Thanks @jdbuchanan71 

This is what I was looking for, I will check for other views on this as well. You're answer will be marked as Accepted solution later.

[TeigeGao]

Hi @Anonymous ,

Any update on this problem?

Best Regards,

Teige