Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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?
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?
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
what do you mean by "apply my calendar function"?
I mean once I execute my function, my calendar function doesn't create any column.
User | Count |
---|---|
66 | |
46 | |
20 | |
18 | |
15 |
User | Count |
---|---|
120 | |
41 | |
40 | |
28 | |
23 |