Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Please help with an alternative to SELECTEDVALUE since this is not supported in excel power query. Here is a sample of what I was trying to do.
Solved! Go to Solution.
Please use
Budget Selected Period =
VAR selectedperiod =
IF (
HASONEVALUE ( SelectPeriod[Select Period] ),
VALUES ( SelectPeriod[Select Period] )
)
RETURN
SWITCH (
TRUE (),
selectedperiod = "Current Month", [Budget CM],
selectedperiod = "Quarter To Date", [Budget QTD],
selectedperiod = "Year to Date", [Budget YTD]
)
Please use
Budget Selected Period =
VAR selectedperiod =
IF (
HASONEVALUE ( SelectPeriod[Select Period] ),
VALUES ( SelectPeriod[Select Period] )
)
RETURN
SWITCH (
TRUE (),
selectedperiod = "Current Month", [Budget CM],
selectedperiod = "Quarter To Date", [Budget QTD],
selectedperiod = "Year to Date", [Budget YTD]
)
User | Count |
---|---|
47 | |
26 | |
22 | |
17 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |