Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello, hoping someday can point me in the right direction.
I'm trying to create a custom calendar with the cycle titles listed in the first column. I've found similar problems in the forum but none that I've been able to implement thus far.
Solved! Go to Solution.
Hi @Jondon29
Not fully understand it. If you create a relationship with the calendar table and fact table, you may link them with Datekey columns. Then the AIRAC can be used for fact table.
Create and manage relationships in Power BI Desktop
Regards,
Cherie
Hi @Jondon29
Could you explain more about your expected output? You may create a custom calendar in query editor or in dax. Please refer to this article to check if it could help you.
How to Get Your Question Answered Quickly
Regards,
Cherie
Thanks @v-cherch-msft.
The article you referenced partially worked; I was able to create a calendar table. I replaced the value MonthID with AIRAC (The name of my periods measured). There are 13 AIRAC periods per calendar year, with the first period of 2018 being AIRAC 1801 through AIRAC 1813. See the picture below for the data.
My only problem is now linking those AIRAC titles with the associated dates. How do I get Power BI to treat AIRAC 1801 as the period of time shown in DateKey.
Hi @Jondon29
Not fully understand it. If you create a relationship with the calendar table and fact table, you may link them with Datekey columns. Then the AIRAC can be used for fact table.
Create and manage relationships in Power BI Desktop
Regards,
Cherie
Hi @Jondon29
Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution and welcome to share your own solution. More people will benefit from here. If not, please share more details for us so that we could help further on it.
Regards,
Cherie
@v-cherch-msft, that solved the problem, I have tagged as the solution. Thank you.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |