Calendar since September Update

[CMAC_Terry]

New to the software but having lots of problems with time deminsions since the Sept 2017 update.

I've imported two cubes from SSAS and used one dataset of date to create a calender: 

Calendar Table = CALENDAR(MIN(FactJourney[Key Date Time]),MAX(FactJobEntry[Key Date.DateTime]))

then created a year column from this table: 

CalendarYear = 'Calendar Table'[Date].[Year]

I have used the calendar table to link the two date columns in my cube imports, when I try to add a year filter form the created column it displays a blank year, there are no blank years in the data?

I had this working fine before but now really struggling, other functions I also had working previoulsy seem to error now since the update, anyone else having problems?

[v-jiascu-msft]

Hi @CMAC_Terry,

Surely the dates are in the 1 side of the relationship. If the dates in the many side that don't exist in the 1 side will lead a blank option in the slicer. Please check it out.

Here is an example.

Calendar 1 =
CALENDAR ( DATE ( 2017, 1, 1 ), DATE ( 2017, 12, 31 ) )

Calendar 2 =
CALENDAR ( DATE ( 2017, 1, 1 ), DATE ( 2018, 1, 5 ) )

Best Regards!

Dale

[CMAC_Terry]

Thanks for the reply Dale,

Not sure, exmaple is below.

Key Date.DateTime is below, the dataset has been set to date, I have duplicated the column and transformed to year format, shown below as Key Date Year.

When I drag the two next to each other into a matrix I get the following results, really weird.

Some years show corrrectly and some are completely wrong.

[v-jiascu-msft]

Hi @CMAC_Terry,

Could you please share your PBIX file?  The picture doesn't show your issue of your first post.

Best Regards!

Dale

[CMAC_Terry]

Is there a way to attach a file, if not I can share the link through one drive to your email address.

[v-jiascu-msft]

Sharing the link of OneDrive is OK. If you can't post it here, you can send me private message.

Best Regards!

Dale

[CMAC_Terry]

https://cmacgroup-my.sharepoint.com/personal/terry_cronshaw_cmacgroup_co_uk/_layouts/15/guestaccess....

I'm trying to create a calendar that links the two datasets so I can cut the Bill Net from both sets by year, month, date etc.

Let me know if the link doesn't work. Thanks for all your help.

Regards, 

Terry

[v-jiascu-msft]

Hi Terry,

You have to share the file first. I can access it.

>>>We're sorry, but xxx can't be found in the cmacgroup-my.sharepoint.com directory. Please try again later, while we try to automatically fix this for you.

Best Regards!

Dale

[CMAC_Terry]

I think I need your email address to share, could you post.

Thanks, 

Terry

[v-jiascu-msft · Accepted solution]

Hi Terry,

The cause is the dates in [fact***entry] are datetime rather than date. I added a new column and changed the relationship. It returns normal now.

New key Date.Datetime = [Key Date.DateTime].[date]

Best Regards!

Dale

[v-jiascu-msft]

Can you share the file publicly? Google Drive, Dropbox are also OK. You can send me  a message.

Best Regards!

Dale

[CMAC_Terry]

Reallly strugging to get Power BI working like I did before the September update, I'm new to using it so not sure if it's me, or something changed with the update.

I've bulk imported from two Cubes in SSAS, after that I've created a calender from one dataset to link to two time dimensions with the below:

Calendar Table = CALENDAR(MIN(FactJourney[Key Date Time]),MAX(FactJobEntry[Key Date.DateTime]))

I have then created a year column from the above, 

CalendarYear = 'Calendar Table'[Date].[Year]

I have created the relationships between the calendar table and the two cubes. When I try to use a Year filter from the calendar table I get a blank year, obvioulsy then any further financial sum measures I create over time are incorrect, anyone know where I'm going wrong?  

Pretty sure I've had this working fine before the last update, also I've notice other DAX formulas behaving differently since update, in that things I've done previously now error.