Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Return (Blank) after replacing data table

Hello,   I replaced a Sales data table. After replacing (loading, transforming, cleaning, formatting etc.) the Sales table seemed to work as well as the old Sales table. However when I managed the...
Pragati11's avatar
Pragati11
Super User
6 years ago

Hi Anonymous ,

 

The format of Calendar-->Date and sale_order-->date_order columns is same right? 

Share some screenshot on data format for these 2 columns.

 

Thanks,

Pragati

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Pragati11 

 

Please find attached the screenshots.

Thanks for your effort, your help is much appreciated 🙂Calendar tableSales table

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    Hi Anonymous ,

     

    Now this is really hard to judge what is wrong.

    Is it possible to share your power bi .pbix file?

     

    Thanks,

    Pragati