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
amitchandak's avatar
amitchandak
Super User
6 years ago

Gingerjeans88 , In case you date column has timestamp. Create a new date column and join that date with that

Date Submitted1 =[Date Submitted].date

Date Submitted Time = [Date Submitted].time

 

Join Date Submitted1  with date table.

For the time you can use time table -https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/

 

refer

YTD : https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
QTD :https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839

 

FY Calendar -https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441

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