Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi ,
I have data in below format
ID | Name | Current Value | Previous Value | Current Fical Year | Previous Year |
111 | Address | 104 Avenue | 103 Avenue | FY25 | FY24 |
112 | Name | John | Mark | FY25 | FY24 |
113 | Name | Ted | Sam | FY24 | FY23 |
114 | Address | 111 Ave | 116 Ave | FY24 | FY23 |
When Fiscal Year Dropdown selected FY25 then matrix show data in below dyamic format
When Fiscal Year Dropdown selected FY24 then matrix show data in below dyamic format
Solved! Go to Solution.
Hi @lutat9063 ,
Here's my test data:
1.Create 4 measures
FY24 =
CALCULATE(
MAX('Table'[Current Value]),
FILTER(
'Table',
'Table'[Current Fical Year] = "FY24"
)
)
Privious(FY23) =
CALCULATE(
MAX('Table'[Previous Value]),
FILTER(
'Table',
'Table'[Previous Year] = "FY23"
)
)
FY25 =
CALCULATE(
MAX('Table'[Current Value]),
FILTER(
'Table',
'Table'[Current Fical Year] = "FY25"
)
)
Privious(FY24) =
CALCULATE(
MAX('Table'[Previous Value]),
FILTER(
'Table',
'Table'[Previous Year] = "FY24"
)
)
2.Create filed parameter
3.Apply parameter as matrix value
4.Create a Fical Year in Parameter table
Fical Year = IF(Parameter[Parameter Order] = 0 || Parameter[Parameter Order] = 2, "FY25", "FY24")
5. Create slicers based on Fical Year
6.Final output
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @lutat9063 ,
Here's my test data:
1.Create 4 measures
FY24 =
CALCULATE(
MAX('Table'[Current Value]),
FILTER(
'Table',
'Table'[Current Fical Year] = "FY24"
)
)
Privious(FY23) =
CALCULATE(
MAX('Table'[Previous Value]),
FILTER(
'Table',
'Table'[Previous Year] = "FY23"
)
)
FY25 =
CALCULATE(
MAX('Table'[Current Value]),
FILTER(
'Table',
'Table'[Current Fical Year] = "FY25"
)
)
Privious(FY24) =
CALCULATE(
MAX('Table'[Previous Value]),
FILTER(
'Table',
'Table'[Previous Year] = "FY24"
)
)
2.Create filed parameter
3.Apply parameter as matrix value
4.Create a Fical Year in Parameter table
Fical Year = IF(Parameter[Parameter Order] = 0 || Parameter[Parameter Order] = 2, "FY25", "FY24")
5. Create slicers based on Fical Year
6.Final output
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @lutat9063
Yes, this is possible with a dynamic measures workaround.
Please refer to the linked videos:
https://www.youtube.com/watch?v=zbKNyFu2BOo
https://www.youtube.com/watch?v=6B-n0xM8ZvA
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
62 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |