Forum Discussion
Compound Fees
YEAR MONTH PREVIOUS VALUE VALUE REND REND% REND TOTAL % 2018 JAN R$ 1.685.515,06 R$ 1.667.048,37 R$ 6.533,31 0,39% 2018 FEV R$ 1.667.048,37 R$ 1.615.559,21 R$ 7.911,80 ...
Hi Brenoo
The table you'd want to iterate in your PRODUCTX is the YEAR and MONTH columns included in the visual.
The ALLSELECTED function gives you the filters applied to the visual as a whole.
So, something like the below, that uses a Date table with Year, Month and YearMonth columns:
REND TOTAL % =
VAR _YearMonths =
FILTER(
ALLSELECTED('Date'[Year],'Date'[Month], 'Date'[YearMonth]),
'Date'[YearMonth] <= MAX('Date'[YearMonth])
)
VAR _Result =
PRODUCTX(
_YearMonths,
[REND%]
)
RETURN
_Result
If I link my original Power bi file and a Excell data may you help me? I really need this calc for my report.
Thanks