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
joe_2802
New Member

Compare values based on date filter

Apologies for a possibly dumb question and thanks in advance:

 

I require to create two tables based on the data both with indepedent date filters. So far, so good.

 

I need a third table however, that gives me the change in carrots and percentage dynamically based on the respective date filters of the two tables. For example:

 

Report 1:

 

DateCategoryCarrotsPercentage
02.03.2017Donald2.630.266.58081,59
02.03.2017Bugs Bunny113.204.1333,51
02.03.2017Micky190.531.0165,91
02.03.2017Goofy186.729.2465,79
02.03.2017Mini53.912.5541,67
02.03.2017Richy48.941.2521,52

 

Report 2:

03.03.2017Donald2.631.032.71481,62
03.03.2017Bugs Bunny115.348.2123,58
03.03.2017Micky186.748.7485,79
03.03.2017Goofy186.875.5535,80
03.03.2017Mini54.630.1541,69
03.03.2017Richy48.949.3971,52

 

How can I report 3 have dynamically calculate based on the respective filters so I can add it to my dashboard?

Report 3:

CategoryChange in CarrotsChange in Percentage
Donald766.1340,02
Bugs Bunny2.144.0800,07
Micky-3.782.267-0,12
Goofy146.3080,00
Mini717.6000,02
Richy8.1460,00

 

Thanks so much!

1 ACCEPTED SOLUTION
v-danhe-msft
Microsoft Employee
Microsoft Employee

Hi @joe_2802,

Based on my test, you could refer to below steps:

Add index columns for your tables:

1.PNG

Merge your two tables as new table

2.PNG

Create customer columns in new table and remove the other columns:

3.PNG

Result:

4.PNG

You could also download the pbix file to have a view

https://www.dropbox.com/s/x52kamo1ygkq1qv/Compare%20values%20based%20on%20date%20filter.pbix?dl=0

 

Regards,

Daniel He

 

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-danhe-msft
Microsoft Employee
Microsoft Employee

Hi @joe_2802,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-danhe-msft
Microsoft Employee
Microsoft Employee

Hi @joe_2802,

Based on my test, you could refer to below steps:

Add index columns for your tables:

1.PNG

Merge your two tables as new table

2.PNG

Create customer columns in new table and remove the other columns:

3.PNG

Result:

4.PNG

You could also download the pbix file to have a view

https://www.dropbox.com/s/x52kamo1ygkq1qv/Compare%20values%20based%20on%20date%20filter.pbix?dl=0

 

Regards,

Daniel He

 

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors