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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Regular Visitor

## Dynamic bands with currency conversion

Hello Experts,

I am looking for a possible solution to accomplish the below use case.

Requirement:

Based on user’s selection on band limit (Amounts), number of policy count has to be reflected in a matrix table.

Raw Data:

 PolicyID Policy Type Amount (INR) P01 Accident 10,000 P02 Life 25,000 P03 Unemployment 50,000 P04 Accident 100,000 P05 Life 75,000 P06 Unemployment 20,000 P07 Accident 30,000 P08 Life 65,000 P09 Unemployment 80,000 P10 Accident 95,000 P11 Life 5,000 P12 Unemployment 15,000

Front End Solution (Without exchange rate conversion):

Below limit options should be flexible for users to pass their values for each bands / limit.

 Limit-1 20,000 Limit-2 50,000 Limit-3 70,000

Based on above inputs from user, table should reflect result as shown below.

 Limit-1 Limit-2 Limit-3 Limit-4 Policy Type <=20,000 >20,000-<=50,000 >50,000-<=70,000 >70,000 Accident 1 1 2 Life 1 1 1 1 Unemployment 2 1 1

Front End Solution (With exchange rate conversion):

 PolicyID Policy Type Amount (Original Currency - INR) Amount (USD) - TOBE CONVERTED IN BACKEND P01 Accident 10,000 120 P02 Life 25,000 300 P03 Unemployment 50,000 600 P04 Accident 100,000 1,200 P05 Life 75,000 900 P06 Unemployment 20,000 240 P07 Accident 30,000 360 P08 Life 65,000 790 P09 Unemployment 80,000 975 P10 Accident 95,000 1,150 P11 Life 5,000 60 P12 Unemployment 15,000 180

Below limit options should be flexible for users to pass their values for each bands / limit.

 Limit-1 300 Limit-2 500 Limit-3 800

 Limit-1 Limit-2 Limit-3 Limit-4 Policy Type <=300 >300-<=500 >500-<=800 >800 Accident 1 1 2 Life 2 1 1 Unemployment 2 1 1

Could you please advise on the steps to implement this in Power BI?

0 REPLIES 0

## Helpful resources

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors