cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

Work in Dynamic calculations

Hi,

 

I've attached a sample data and my requirement is to get the resultant dataset (On Right in attachment) after multiplying with Selected Multiplication value in the data. The selection value can be from  1 to 10 by user.

 

https://drive.google.com/file/d/1oN9VYGRbmWeUrxhiWtJXjfTKB6dpI6AW/view?usp=sharing

 

REgards.

1 ACCEPTED SOLUTION

Accepted Solutions
Tahreem24 Member
Member

Re: Work in Dynamic calculations

Hi @chandra_0202,

I have created step by step solution for you.

Please mark my answer as a solution so that it may helpful for others.

 

 

Sol.PNG 

5 REPLIES 5
Tahreem24 Member
Member

Re: Work in Dynamic calculations

Hi,

 

I might have found the answer of your question. You can achieve this using What-if-Parameter. 

I have created sample of your data and achived the expected result in below screen shots.

 

Capture.PNGUser Input is 2Capture2.PNGUser Input is 4

Tahreem24 Member
Member

Re: Work in Dynamic calculations

Hi @chandra_0202,

I have created step by step solution for you.

Please mark my answer as a solution so that it may helpful for others.

 

 

Sol.PNG 

Tahreem24 Member
Member

Re: Work in Dynamic calculations

Hi @chandra_0202 ,

 

I hope I answered your doubt so please mark my effort as a solution Smiley Happy. It may also help others.

 

Re: Work in Dynamic calculations

Thanks it works for me.

 

Appreciate your Help.

Tahreem24 Member
Member

Re: Work in Dynamic calculations

Great! Good to know that defined solution worked for you.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 263 members 2,977 guests
Please welcome our newest community members: