Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have a calendar with fiscal year and in a matrix table. How do you add a measure to have the third column as the difference between the amounts from the 2 fiscal years (22-23 and 23-24)? Thanks.
(subtract per month between 2 fiscal years)
Solved! Go to Solution.
@Oros I think you will need to create a measure for each respective year (i.e. [Measure22-23], [Measure23-24] ) and then another subtraction measure which will be [Measure23-24] - [Measure22-23]. Then you will need to add the three measures to the Matrix visual.
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
@Oros I think you will need to create a measure for each respective year (i.e. [Measure22-23], [Measure23-24] ) and then another subtraction measure which will be [Measure23-24] - [Measure22-23]. Then you will need to add the three measures to the Matrix visual.
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Pleasure @Oros
All the best! 🙂
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
User | Count |
---|---|
98 | |
91 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |