Calendar function - Nothing appears

[Sami_nl]

Hello,Data-CALANDAR-DAX

I am new with Power BI so I need some help about some projects that I have since a few days. I am actually working on an open source project with Wallmart 's data. I'm trying to create a calendar function with fax in order to analyse my data in a certain period of years.
However, I don't know why, but when I apply my calendar function nothing appears. I mean there is not any error message, but any column created.
What should I do? I need some help please.

[tamerj1 · Accepted solution]

Hi @Sami_nl 
First you are creating a measure while you need a calculated column. 2nd, you are using a table function (CALENDAR) to return a scallar value which is not allowed. Can you please advise what is the expected result that you are looking for?

[Sami_nl]

Hi , 

Your are right it was not possible . So I did it with the M language. I created a list and then convert it .

List.Dates(#date(2011, 12, 31), 5, #duration(1, 0, 0, 0)).

Thank you very much

[FreemanZ]

what do you mean by "apply my calendar function"?

[Sami_nl]

I mean once I execute my function, my calendar function doesn't create any column. execute_function