Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
How can I write a DAX formula to calculate the sum of the previous quarter revenue and multiply that total by 4?
Solved! Go to Solution.
Hi @Anonymous,
Try create a DAX column with this formula:
previousquarter = CALCULATE ( SUM ( 'Table'[Revenue] ); ALL ( 'Table' ); PREVIOUSQUARTER ( 'Table'[Revenue Date] ) ) * 4
Regards.
Note: If you get a syntax error it's probably because of the semicolons instead of commas, Power BI has the two options to delimit DAX, change semicolons by commas and it should work.
Hi @Anonymous,
Try create a DAX column with this formula:
previousquarter = CALCULATE ( SUM ( 'Table'[Revenue] ); ALL ( 'Table' ); PREVIOUSQUARTER ( 'Table'[Revenue Date] ) ) * 4
Regards.
Note: If you get a syntax error it's probably because of the semicolons instead of commas, Power BI has the two options to delimit DAX, change semicolons by commas and it should work.
Hi @Anonymous,
I am getting nothing by using this formula. Can you explain to me why I am getting nothing?
Thanks,
Arvind