Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello to all,
I need a big help creating two mesures:
1st - Fees for the Shareholders : I need help creating a formula that Calculate the amont of fee one shareholder must Pay, to do so I must create a sum of fees of "Forecast" by date (Month) multiplied by the share that shareholder holds in the SPE (Company)
Translates:
2nd - Create a Mesure that see the amount of money one shareholder imput in the SPE (Company) by time less the Fees for the Shareholders create in the first question.
Translates:
The logic behind this Mesures is first, identify the need of pay for any shareholder, and the need of pay equals to the sum of "Previsão" multiplied by the share of each shareholder.
After get what each shareholder must pay, we see the amount of money thei inject in this company, and see if the shareholder has a debt or a credit (Aporte), this seen by time (Year, quarter or month)
The PBI file and database is in the link: https://goo.gl/F0EY3E
Thx for the help, and if i get myself unclear, just ask anyting.
Solved! Go to Solution.
Hi @DiogoValentim,
You can take a look at below formulas if it works on your side:
Previsao(Data&SPE) =
var currSPE=LASTNONBLANK(Tbl_PlanodeContas[SPE],[SPE])
var currDate=MAX([Data])
Return
SUMX(FILTER(ALL(Tbl_PlanodeContas),[SPE]=currSPE&&[Data]=currDate),[Valor])
Current Spend =
var currDate=MAX([Data])
var currSPE=LASTNONBLANK(Tbl_AporteAcionista[SPE],[SPE])
var currAcionista=LASTNONBLANK(Tbl_AporteAcionista[nAcionista],[nAcionista])
Return
SUMX(FILTER(ALL(Tbl_AporteAcionista), [nAcionista]=currAcionista&&[SPE]=currSPE&&[Data]=currDate),[Aporte])
Need Spend =
CALCULATE([Previsao(Data&SPE)],VALUES(Tbl_AcionistaEmpresa[SPE]))* MAX([Participacao])
Result:
Regards,
Xiaoxin Sheng
Hi @DiogoValentim,
You can take a look at below formulas if it works on your side:
Previsao(Data&SPE) =
var currSPE=LASTNONBLANK(Tbl_PlanodeContas[SPE],[SPE])
var currDate=MAX([Data])
Return
SUMX(FILTER(ALL(Tbl_PlanodeContas),[SPE]=currSPE&&[Data]=currDate),[Valor])
Current Spend =
var currDate=MAX([Data])
var currSPE=LASTNONBLANK(Tbl_AporteAcionista[SPE],[SPE])
var currAcionista=LASTNONBLANK(Tbl_AporteAcionista[nAcionista],[nAcionista])
Return
SUMX(FILTER(ALL(Tbl_AporteAcionista), [nAcionista]=currAcionista&&[SPE]=currSPE&&[Data]=currDate),[Aporte])
Need Spend =
CALCULATE([Previsao(Data&SPE)],VALUES(Tbl_AcionistaEmpresa[SPE]))* MAX([Participacao])
Result:
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |