Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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 , what does AGO function do.
Can you explain what you want ?
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |