Forum Discussion

bsz412's avatar
bsz412
Icon for Helper III rankHelper 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
Icon for Super User rankSuper 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
Icon for Helper III rankHelper III
4 years ago

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