Want to Show accuracy between current and historic entries of Same time period

[AshDil]

Hi,

I have main table and history table in sql for forecast sale values.

Beginning of July, I'll get values for July , aug, sep months in sql. After fortnight again values get updated for July,Aug,Sep.

Beginning of Aug month, I'll get values for Aug, sep,oct in sql. They update values for Aug, Sep and gives new values for Oct.

After fortnight again values get update for Aug, Sep, Oct.

Beginning of Sep month, I'll get values for Sep,Oct and Nov in sql. They update values for Sep,Oct and gives new values for Nov. After fortnight again values get update for  Sep, Oct, Nov. and So on.

When ever data gets updated in main table, all history values will be saved in history table in every instance. You can see how my data gets updated in reply.

Now I need to show comparison among historical 1, historical 2 , historical 3 and current values for months Sep, Oct,Nov.........

I'll get data as follows:

Beginning of the July,

Main table:

History Table:

After fortnight in July,

Main table:

History Table:

Beginning of August,

Main table:

History Table:

After fortnight in August,

Main table:

History Table:

This is how data gets updated every fortnight.

Please help me to do it.

Thanks,

AshDil.

[v-rzhou-msft]

Hi @AshDil 

From your statement, I think you want to refresh values in a dynamic date range.

Please try Incremental refresh for datasets in Power BI.

For reference:

Incremental refresh for datasets

Configure incremental refresh

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AshDil]

Hi @v-rzhou-msft , 

Please elaborate me, with dynamic refresh how would I get following result output in Power Bi

Thanks,

AshDil.