Forum Discussion
Tableau to Power BI
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
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
3 Replies
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
- amitchandak
Super User
Anonymous , what does AGO function do.
Can you explain what you want ?
