Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Relationship between date table and data table (with null date)

Hi guys,   I have 2 tables INVOICE and DATE   Date table =   ADDCOLUMNS( calendar(min(INVOICE[INVOICE DATE]), EOMONTH(TODAY(),-1)), "MonthNum", MONTH([Date]), "Month", FORMAT([Date], "MMMM...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , I think there are missing date, try like

 

 

 

ADDCOLUMNS(

calendar(min(INVOICE[INVOICE DATE]), EOMONTH(Max(INVOICE[INVOICE DATE]),0)), 

"MonthNum", MONTH([Date]),
"Month", FORMAT([Date], "MMMM"),

"Year", YEAR([Date])
)