CLENDAR function

[waleed111]

when i write this formula in pbi it show same value for all rows:

date = CALENDAR(MIN('List View'[start date]), MIN('List View'[start date]))

what is the problem?

[ryan_mayu · Accepted solution]

@waleed111 

I think you are creating a column. You need to create a table.

[amitchandak]

@waleed111 ,

This is strange

Try like

date = CALENDAR(MIN('List View'[start date]), Max('List View'[start date]))

or

date = CALENDAR(MIN('List View'[start date].date), Max('List View'[start date].date))

Can you share a sample pbix after removing sensitive data.

[waleed111]

date = CALENDAR(MIN('List View'[start date]), MAX('List View'[end date]))

it show this error: A table of multiple values was supplied where a single value was expected.

[v-deddai1-msft · Accepted solution]

Hi @waleed111 ，

Are you trying to create a date dimension table in Power BI? Just as mentioned by ryan_mayu, use create table not calculated column. 

datetable = CALENDAR(MIN('List View'[start date]), MAX('List View'[end date]))

If you want to create a date dimension table that are suitable for multiple date granularity, you could refer to Using a Date Dimension Table in Power BI

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[ryan_mayu · Accepted solution]

@waleed111 

I think you are creating a column. You need to create a table.

[Anonymous]

Use below code, You are using same reference date twice.
date = CALENDAR(MIN('List View'[start date]), MAX('List View'[start date]))

[Anonymous]

Use CALENDARAUTO function for that column:

date=CALENDARAUTO('List View'[start date])