topic Re: Calendar function - Nothing appears in DAX Commands and Tips

Calendar function - Nothing appears

Sami_nl — Mon, 05 Dec 2022 10:39:25 GMT

Hello,

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.

Re: Calendar function - Nothing appears

FreemanZ — Mon, 05 Dec 2022 11:01:27 GMT

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

Re: Calendar function - Nothing appears

Sami_nl — Mon, 05 Dec 2022 11:09:05 GMT

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

Re: Calendar function - Nothing appears

tamerj1 — Mon, 05 Dec 2022 12:02:40 GMT

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?

Re: Calendar function - Nothing appears

Sami_nl — Mon, 05 Dec 2022 15:04:27 GMT

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