Forum Discussion
Neil_Cooper
Helper I
3 years agoMatrix Table showing Month/Year after today....
Hi Everyone I wonder if you can help me. I am working on displaying attriton data and for some reason when putting this into the Matrix visual it is showing me the results for the entire year ra...
Ritaf1983
Super User
3 years agoHi Neil_Cooper
Try to add to your date table flag column
Is_before_taday = if (dim_date[date] <=today(),1,0)
And then put it on page/visual filters by 1.
If i isn't work please share your sample PBIX
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Neil_Cooper
Helper I
3 years agoThank you so much for the reply but sadly this didnt work. I tried to use this as a filter but it only had the selection of "1" and nothing else to filter out
- Ritaf19833 years ago
Super User
Hi Neil_Cooper as I said previously i need your sample PBIX to help more...