Forum Discussion

CMAC_Terry's avatar
CMAC_Terry
Helper I
8 years ago
Solved

Calendar since September Update

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 Ta...
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    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

CMAC_Terry's avatar
CMAC_Terry
Helper I
8 years ago

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.