Forum Discussion

Sami_nl's avatar
Sami_nl
New Member
3 years ago
Solved

Calendar function - Nothing appears

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 ...
  • 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?

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