Forum Discussion

Gingerjeans88's avatar
Gingerjeans88
Helper IV
6 years ago

Calendar Table Issues - all visuals blank

Please help, I am SO lost. I have managed to get by without a calendr table thus far, but I need to do some time intelligence functions for a custom fiscal year period which necessitates having one. ...
Need Help
Gingerjeans88's avatar
Gingerjeans88
Helper IV
6 years ago

Hi there amitchandak 

 

Thank you SO much for the speedy reply. 

However, I am not sure I follow? 

 

The date column in my fact table is date/time format and it already has a time value. Would I still need to do this?

v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi Gingerjeans88 ,

 

Please post the sample fact table.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Gingerjeans88's avatar
    Gingerjeans88
    Helper IV
    6 years ago

    Hi v-lionel-msft  thank you SO much!! I am getting desperate. 

     

    I have mocked up some data, it is in the attache dropbox link - but I have not related the date table to the fact tables, as that is the bit I am hoping you'll help me with. 

    If my academic year begins on 31st August, is my '9' for start of academic year parameter incorrect? 

     

    https://www.dropbox.com/s/e04qd29o94ildpq/Sample%20PBIX%20-%20Applications.pbix?dl=0 

     

    In my real pbix I have lots more fact tables all related to one another. 

     

    Many thanks,

     

    Lynn