Forum Discussion

kevinjhon's avatar
kevinjhon
New Member
4 years ago

Calendar table does not work

boa noite,

Estou estudando power BI e tinha uma dúvida.

Crie uma tabela de calendário para listar ou relacionar com uma base de vendas "oficial", que acontece mesmo seguindo todos os procedimentos e categorizando os dados de acordo com ela ou determinado, o que não aparece. Pode me ajudar?

 

 

 

 

 

 

Alguém pode me dizer onde estou errando?

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    One possibility is that the date in the data table contains hours, minutes and seconds.you can check the date in the data table . If so, you can use Power Query to convert it into date format and clear the hours，minutes and seconds later.😊

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    4 years ago

    Hi kevinjhon ,


    Do you have the following options turned on. When a date column is created, the Date/Time format is automatically generated. You need to convert it to a Date field and try again.


    If the problem persists, can you provide information on the specific formula that was created? Looking forward to your feedback.


    Best Regards,
    Henry


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