How to implement AGO in POWER BI

Question

Hi,&nbsp;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.&nbsp;&nbsp;

sunilmauryapbi · Answer

Any help will be appreciated? I want 4 measures to be in place likeStock price 1 month agoStock price 3 month agoStock price 6 month agoStock price 12 month ago

v-yulgu-msft · Answer

Hi&nbsp;SunilMauryaPBI,
&nbsp;

Remove the relationship between 'Date Dimention' and 'Stock Price Fact'.
Create calculated columns, for example, calculate the date one month ago. 1&nbsp;month&nbsp;ago&nbsp;=DATEADD&nbsp;(&nbsp;'Date&nbsp;Dimention'[Calendar_Date],&nbsp;-1,&nbsp;MONTH&nbsp;). Set its format to "MMMM yyyy" under Format list in top ribbon.
Add 'Date Dimention'[CAL_MONTH] to slicer. Add 'Stock Price Fact'[RWPORTING_PERIOD_ID] to table visual.
Create measures:
Selected&nbsp;value&nbsp;of&nbsp;1&nbsp;month&nbsp;ago&nbsp;=SELECTEDVALUE&nbsp;(&nbsp;'Date&nbsp;Dimention'[1&nbsp;month&nbsp;ago]&nbsp;)

%&nbsp;Mov&nbsp;1&nbsp;Month&nbsp;Ago&nbsp;=
&nbsp;(
&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE&nbsp;(
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[Sum&nbsp;value],
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FILTER&nbsp;(
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Stock&nbsp;Price&nbsp;Fact',
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;YEAR&nbsp;(&nbsp;'Stock&nbsp;Price&nbsp;Fact'[EFFDATE]&nbsp;)&nbsp;=&nbsp;YEAR&nbsp;(&nbsp;[Selected&nbsp;value&nbsp;of&nbsp;1&nbsp;month&nbsp;ago]&nbsp;)
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&amp;&nbsp;MONTH&nbsp;(&nbsp;'Stock&nbsp;Price&nbsp;Fact'[EFFDATE]&nbsp;)
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;MONTH&nbsp;(&nbsp;[Selected&nbsp;value&nbsp;of&nbsp;1&nbsp;month&nbsp;ago]&nbsp;)
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)
&nbsp;&nbsp;&nbsp;&nbsp;)
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-&nbsp;[Sum&nbsp;value]
)
&nbsp;&nbsp;&nbsp;&nbsp;/&nbsp;[Sum&nbsp;value]

Regards,
Yuliana Gu

Forum Discussion

How to implement AGO in POWER BI

2 Replies

Related content

Power Query Implementation

MDM implementation

Report Server Implementation

Best Implementation Practices

Implementing Fabric Apps by Rayfin SDK