Tableau to Power BI

[Anonymous]

I am currently working on migrating Tableau Reports to Power BI. I am currently facing problems in converting the the Tableau Calculation to DAX in Power BI. Needed help in this.

The expression is: AGO(W_RENTAL_TRANS_F.TRANSACTION, W_MCAL_DAY_D.MCAL_YEAR,1)

What should the equivalent DAX Expression be?

W_RENTAL_TRANS_F  and W_MCAL_DAY_D are tables, TRANSACTION and MCAL_YEAR are columns

[v-shex-msft · Accepted solution]

Hi @Anonymous,

I'm not so sure what type of database are you worked with? Can you please share more about these? 

How to Get Your Question Answered Quickly

If you mean the previous date of the specified date range, you can take a look at the following link about time intelligence functions.

SAMEPERIODLASTYEAR function (DAX) - DAX | Microsoft Docs
Regards,

Xiaoxin Sheng

[Anonymous]

@v-shex-msft Thanks a lot. This DAX function helped me achieve what I want 

[amitchandak]

@Anonymous , what does AGO function do.

Can you explain what you want ?