Forum Discussion

Sami_nl's avatar
Sami_nl
New Member
3 years ago
Solved

Calendar function - Nothing appears

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's avatar
    tamerj1
    3 years ago

    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?

4 Replies

    • Sami_nl's avatar
      Sami_nl
      New Member
      3 years ago

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

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    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's avatar
      Sami_nl
      New Member
      3 years ago

      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