The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
95 | |
94 | |
85 | |
69 | |
65 |
User | Count |
---|---|
240 | |
125 | |
122 | |
82 | |
80 |