Good afternoon people,
I have a complex question and I don't know how to translate this into power bi, my direct connection to the bank in SQL.
Can anybody help me?
6.1 Rules
• Report should display the results according to the criteria;
• The sum of the results of all criteria will be the total of the lot;
6.1 Criteria:
• Balance ranges, report should distribute the results in the following balance ranges (information extracted from column H of the base):
0 to R $ 4,999.99
R $ 5,000.00 to R $ 9,999.99
R $ 10,000.00 to R $ 19,999.99
R $ 20,000.00 to R $ 29,999.99
above R $ 30,000.00
• PMT paid, report should distribute the amounts according to the amount of installments paid according to the active base, if the operation does not have this data in the active base this indicator will be blank (information extracted from column J of the base):
the 0 to 6
the 7 to 12
the 13 to 15
the 16 to 24
o> = 25
• Proponent Bank, report should distribute the amounts according to the proponent bank of the asset base, if the operation does not have this data in the base this indicator will be blank (information extracted from column Q of the base):
• Source rate, report should distribute the values according to the “source rate” ranges of the asset base, if the operation does not have this data in the base this indicator will be blank: (base does not have this information)
0 to 1.30%
1.31% to 1.40%
o 1.41% to 1.50%
o 1.51% to 1.60%
o 1.61% to 1.70%
o 1.71% to 1.80%
o Above 1.81%
• Rate of the proposing bank, report should distribute the values according to the “rate of the proposing bank” of the asset base, if the operation does not have this data in the base this indicator will be blank (information extracted from column I of the base) :
0 to 1.30%
1.31% to 1.40%
o 1.41% to 1.50%
o 1.51% to 1.60%
o 1.61% to 1.70%
o 1.71% to 1.80%
o Above 1.81%
