Forum Discussion
Help with Time Intelligence on two data bases
Hello.
Im having a hard time trying to solve this so i come for help once again. I have 2 different data sets. One includes all the costs related to the company from 2020 and the other is a current cost database from 2021 up until now.
I was told to create a calendar so I made one from Jan 01 2020 to Dec 31 2021. What I want to do is to show monthly and do a comparison between these two. But whenever I linked them into my the database all costs from 2020 are condensed into one (for example if I had 20,000 in costs for the whole year it shows like this:
Jan , 20,000
Feb 20,000
and so on. When in reality January is around 1,500 for saying a number.
I believe this has to do something with the relationships, or maybe im doing this the wrong way and should be using measures for this.
Any help would be appreciated.
I just changed the column names and did a quick restart and everything is working now. The calendar table was the real deal in here.
5 Replies
How do you create the custom Calendar. Through DAX or Power Query?
Can you also show us the relationship between the tables?
Hello,
For the calendar I used the following measure after creating a table.
Calendar = CALENDAR(DATE(2020,1,1),DATE(2021,12,31))The two databases come in Spanish and the calendar (and the rest of the power BI) comes in english. Everything is supposed to be checked on a monthly basis so there is no need to have a daily slicer for it.
Any help would be appreciated.Regarding the relationships here is a picture.Do you use a specific formula to calculate the cost?
Any chance to share the workspace with us? Hide any sensitive data
Right now im not going through advanced financial features. Trying to get this working before everything unfolds. I am not having any calculations for the cost, as they all raw from the database. I just cant link the sets not even with the created calendar.
I just changed the column names and did a quick restart and everything is working now. The calendar table was the real deal in here.
