Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Let's say I have a simple table with Months and value
Jan | 5 |
Feb | 7 |
Mar | 2 |
Is there a way to display the last value (without any calculation or sum) of the latest month selected (even when there's multiple month selected).
Ex.:
You select Jan, it shows 5
You select Q1 (Jan+Feb+Mar) it shows 2
Thanks you.
Solved! Go to Solution.
Last month selected value =
var _mIndex =MAX(texx[Index])
var _calc = CALCULATE(MAX(texx[Column2]),texx[Index]=_mIndex)
return _calc
Proud to be a Super User!
Last month selected value =
var _mIndex =MAX(texx[Index])
var _calc = CALCULATE(MAX(texx[Column2]),texx[Index]=_mIndex)
return _calc
Proud to be a Super User!
Hi All,
i thought i would post on a thread which is close to the solution i am looking for, but not quite.
I have two months selected in a slicer which produce an interest rate correctly if i make a single selection.
Interest Rate =
CALCULATE(
CALCULATE(
SUMX('EOM Balance','EOM Balance'[AccountBalance] *
'EOM Balance'[InterestRate]) /
'EOM Balance'[Month End Balance]),
USERELATIONSHIP('EOM Balance'[SnapshotDate],'Date'[Date])) /
100
when i make a multiple selection, i would like the interest rate for the most recent month.
i.e. March is 1.3 and April is 1.4
if i select March and April i would like for it to show April.
but cant seem to get it to work.
any help would be appreciated
Hi @Cpaterson ,
You are welcome! Thank you for the kind words.
Nathaniel
Proud to be a Super User!
User | Count |
---|---|
41 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |