Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
You could try the following:
Test Site Threshold =
VAR ProgramSelected =
SELECTEDVALUE ( 'Master BTPP Report'[Program] )
VAR YearSelected =
SELECTEDVALUE ( 'Master BTPP Report'[Application Received Date].[Year] )
RETURN
IF ( YearSelected = 2019,
SWITCH (
ProgramSelected,
"Charge Ready Bridge",5,
"T1",6,
"T2",7,
"T3",8,
"T4",9,
"T4",10,
0 ),0)
If I answer your question, please mark my post as a solution, this will also help others.
Please give Kudos for support.
Tomas Santandreu Polanco |Principal Business Intelligence Consultant
www.designmind.com
You could try the following:
Test Site Threshold =
VAR ProgramSelected =
SELECTEDVALUE ( 'Master BTPP Report'[Program] )
VAR YearSelected =
SELECTEDVALUE ( 'Master BTPP Report'[Application Received Date].[Year] )
RETURN
IF ( YearSelected = 2019,
SWITCH (
ProgramSelected,
"Charge Ready Bridge",5,
"T1",6,
"T2",7,
"T3",8,
"T4",9,
"T4",10,
0 ),0)
If I answer your question, please mark my post as a solution, this will also help others.
Please give Kudos for support.
Tomas Santandreu Polanco |Principal Business Intelligence Consultant
www.designmind.com
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |