Forum Discussion

te271203's avatar
te271203
Regular Visitor
3 months ago
Solved

Tableau to PowerBI Running Totals Issue

Hello all,   I have two data sets: one is in a Redshift table and the other is an Excel file containing monthly totals for the table's data set.   Attached are screenshots from Tableau and PowerB...
Need Help
Tips and Tricks
  • te271203's avatar
    te271203
    2 months ago

    Thanks for reaching out. I was able to solve it using a Python script and by adding a few New Data Model tables with joins, which helped me get the cumulative dashboard aligned with the target.

v-karpurapud's avatar
v-karpurapud
Community Support
2 months ago

Hi te271203 

Just checking in as we haven't received a response to our previous message. Were you able to review the information above? Let us know if you have any additional questions.

Thank You.

te271203's avatar
te271203
Regular Visitor
2 months ago

Thanks for your concern. Somehow, i couldn't able to do it due to the structure of the data between databrcick table and target excel file without having any key combinations. Is there a way, i can share you the data and try. please assist.

  • v-karpurapud's avatar
    v-karpurapud
    Community Support
    2 months ago

    Hi  te271203 

    Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot). Include all the necessary details, detailing your scenario and issue as clearly and fully as possible. 


    Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

    Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI…



    Best regards,
    Community Support Team.

     

    • v-karpurapud's avatar
      v-karpurapud
      Community Support
      2 months ago

      Hi te271203 

      We have not received an update from you for some time. To assist you in resolving the issue, we kindly request that you provide the necessary details. Once we have this information, we will be able to address your concern effectively.

      Thank you.

      • te271203's avatar
        te271203
        Regular Visitor
        2 months ago

        Thank you for reaching out, and apologies for the delay.

         

        Since this solution isn't working, I'm attempting to join or merge the actual and target table/file data using an ETL approach to obtain the correct data.

         

        As I can't share full data here, I'm not sure I can fully explain the issue.

        I'll get back to you once I have the dataset ready for any further questions.

         

        Thanks again.