Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Tracking Daily Revenue Delta Between Static and Dynamic Tables in Power BI

i am trying to find delta (difference) between 2 tables (vw__sales_baseline) & (vw__sales_current) loaded in power bi. both the tables are identical (pulled from same source), i have just duplicated...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    Hi Anonymous  -You need a way to persist data so that vw__sales_baseline remains unchanged Monday-Saturday and updates only on Sunday.

    Steps:
    Create a Storage Table:

    Use an external database (Databricks, SQL Server, or SharePoint List) to store the vw__sales_baseline snapshot each Sunday.
    Modify Your Power Query to Read from This Storage Table:

    Load vw__sales_baseline only if today is not Sunday (i.e., Monday-Saturday).
    Refresh vw__sales_baseline on Sunday and store the latest data.

     

    If you have access to an external database (SQL, Databricks, SharePoint List).

     

    Hope this helps.

     

rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

Hi Anonymous  -You need a way to persist data so that vw__sales_baseline remains unchanged Monday-Saturday and updates only on Sunday.

Steps:
Create a Storage Table:

Use an external database (Databricks, SQL Server, or SharePoint List) to store the vw__sales_baseline snapshot each Sunday.
Modify Your Power Query to Read from This Storage Table:

Load vw__sales_baseline only if today is not Sunday (i.e., Monday-Saturday).
Refresh vw__sales_baseline on Sunday and store the latest data.

 

If you have access to an external database (SQL, Databricks, SharePoint List).

 

Hope this helps.