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 ,

 

Try creating a new Calendar Table i,e CalendarTable1.

 

Create the relationship with CalendarTable1 and see if you are getting the results.

 

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 

 

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