Forum Discussion

Gingerjeans88's avatar
Gingerjeans88
Icon for Helper IV rankHelper 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
v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity 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
Icon for Helper IV rankHelper 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