Forum Discussion

faisayed's avatar
faisayed
Frequent Visitor
3 years ago
Solved

Future Months Showing In Bar Graph

Hi Team,   I have created a Date table with formula Reference Table = CALENDAR(DATE(2022,1,1),DATE(2023,1,31)) which gives me dates from 1st Jan 2022 till 31st Jan 2023. However when I am uising t...
Need Help
  • pratyashasamal's avatar
    pratyashasamal
    3 years ago

    Hi faisayed ,
    You can add column MonthYear Column in Reference Table that has Month+ Year .And then use that as a filter .
    Thanks ,
    Pratyasha Samal
    Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
    If you found this post helpful, please give Kudos C

pratyashasamal's avatar
pratyashasamal
Memorable Member
3 years ago

Hi faisayed ,
Please try to us CALENDERAUTO () function for this .
Please refer to this link :- https://learn.microsoft.com/en-us/dax/calendarauto-function-dax
If still the issue remains you can simply use filter and remove all the future months .
Thanks ,
Pratyasha Samal 
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C