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

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

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's avatar
CMAC_Terry
Helper I
8 years ago

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's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    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's avatar
      CMAC_Terry
      Helper I
      8 years ago

      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's avatar
        v-jiascu-msft
        Microsoft Employee
        8 years ago

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

         

        Best Regards!

        Dale