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
Hi,
I need help to understand how i can implement AGO type measures in POWER BI.
I need to display conversion price for yyyy/mm selected by user along with its values 1 month back, 3 month back, 6 month back and 12 month back. For example:-
If 2018/03 is slected, then row should look like this and I placed the model in below.
Hi @SunilMauryaPBI,
Selected value of 1 month ago =SELECTEDVALUE ( 'Date Dimention'[1 month ago] ) % Mov 1 Month Ago = ( CALCULATE ( [Sum value], FILTER ( 'Stock Price Fact', YEAR ( 'Stock Price Fact'[EFFDATE] ) = YEAR ( [Selected value of 1 month ago] ) && MONTH ( 'Stock Price Fact'[EFFDATE] ) = MONTH ( [Selected value of 1 month ago] ) ) ) - [Sum value] ) / [Sum value]
Regards,
Yuliana Gu
Any help will be appreciated? I want 4 measures to be in place like
Stock price 1 month ago
Stock price 3 month ago
Stock price 6 month ago
Stock price 12 month ago
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 |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
247 | |
122 | |
110 | |
77 | |
72 |