Forum Discussion
Gingerjeans88
6 years agoHelper IV
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. ...
v-lionel-msft
6 years agoCommunity Support
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
6 years agoHelper IV
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