Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
harshadrokade
Post Partisan
Post Partisan

Variance between two date values of specific stage

Hi sir,mam,

 

Thanks for looking into the queruy.

 

I have data as given below. I want to find the variance between two dates in sequence and show the same in a line chart. How can I achive the same?

 

I have given the example of output as well as base data

 

Both Base data tables (Stage table and amount tables are connected with each other with ID column.)

Base data- Stage table

IDDateStage
116-10-23A
216-10-23A
316-10-23A
417-10-23A
517-10-23A
617-10-23A
718-10-23A
818-10-23A
918-10-23A
1016-10-23B
1116-10-23B
1216-10-23B
1316-10-23B
1417-10-23B
1517-10-23B
1617-10-23B
1717-10-23B
1818-10-23B
1916-10-23C
2017-10-23C
2117-10-23C
2217-10-23C
2317-10-23C
2417-10-23C
2517-10-23C
2618-10-23C
2718-10-23C

 

Base data- Amount table

IDAmount
179
238
315
468
516
626
786
884
958
1020
1163
1286
1359
1421
1572
1676
1752
1865
1946
2018
2149
2246
2337
2444
2547
2678
2764

 

Output table visual expected as below

 

Column A, B and C are calculated as total amount of all IDs that are having respective date and stage. 

Column Variance are calculated by deducting the latest date value from previous date value.

 

DateAVariance ABVariance BCVariance C
16-10-2313202280460
17-10-23110-22221-7241195
18-10-2322811865-156142-99

 

I could achieve generation of column A, B and C. How do I bring the variance column values to the table visual?

 

Regards,

Harshad

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

Hi,

PBI file attached.

Hope this helps.

Ashish_Mathur_0-1697414497087.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

1 REPLY 1
Ashish_Mathur
Super User
Super User

Hi,

PBI file attached.

Hope this helps.

Ashish_Mathur_0-1697414497087.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.