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.

Reply
Vijay_Madhav
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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Fabric Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.