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...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous 

 

Thnx for your input!

 

I copied the calendar in Powerquery to calendar2. 

It does return a value in the visuals now. I don't know what was wrong with the old calendar then.

 

However it still isn't possible to filter properly. When I try to filter an month/week or  other, value returned remains sum/total  of selected columns.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

can you share your .pbix file.

 

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous & Pragati11 

     

    thanks for all your efforts in trying to help me.

    I connected the PBIX with a sql db server and unfortunately I can not share these credentials with you.

     

    I think it's best I just start from scratch again. Makes for good pratice I reckon.

     

    Regards,

    Marc