Forum Discussion

waleed111's avatar
waleed111
Helper V
6 years ago

calendar cannot be blank

when i use this formula: Date = CALENDAR('List View'[start date], 'List View'[end date]) it show me this error: The start date or end date in Calendar function can not be Blank value.
Need Help
waleed111's avatar
waleed111
Helper V
6 years ago

You want to add a column with all the dates in possible in your table? yes

MFelix's avatar
MFelix
Super User
6 years ago

Hi waleed111 ,

 

Sorry for the followup questions but to what I uderstand you want to had all the dates in other tables, so if you have a table 1 that has let's assume values for the 1st week for January and you maximum date is the last day of january you table will have a lot of blanks values except for the date:

 

Table1 (before column)

Date Value
01/01/2020 10
02/01/2020 30
03/01/2020 40
04/01/2020 50
05/01/2020 60

 

Table1 (after column)

Date Value New Date
01/01/2020 10 01/01/2020
02/01/2020 30 02/01/2020
03/01/2020 40 03/01/2020
04/01/2020 50 04/01/2020
05/01/2020 60 05/01/2020
    06/01/2020
    07/01/2020
    ...
    29/01/2020
    30/01/2020
    31/01/2020

 

Is the representation above correct?

 

If that is the expected result, and once again I apologize why don't you use a calendar table to make the relationship with you table that will return the values that you need and make it more dinamic without the need to duplicate values. Also this type of merge is better made in Power Query than in dax because when you want to had new rows you need to make a new table.