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 

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.

  • te271203's avatar
    te271203
    Regular Visitor
    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 

    Thank You for the Update.

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

    Hi te271203 

    We wanted to follow up as we haven’t received a response yet.  If you have any questions or need further assistance, feel free to reach out.

    Regards,

    Microsoft Fabric Community Support Team.