Forum Discussion

bsz412's avatar
bsz412
Helper III
4 years ago

Calendar table strange behavior

Hi,    I have a calendar table created as below:  Calendar = var FullCalendar = ADDCOLUMNS(CALENDAR(MIN(sales_purchase[Date]),MAX(sales_purchase[Date])),"Month Number",MONTH([Date]),"Year",YEAR([...
Need Help
johnt75's avatar
johnt75
Super User
4 years ago

I think Power BI is using an automatically created calendar table, which always has dates covering entire years. If you add the column I suggested you should be able to filter out all the dates after today

  • bsz412's avatar
    bsz412
    Helper III
    4 years ago

    unfortunately it doesnt work. I will try to create a new calendar table