Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Previous Quarter

1.PNG

 

How can I write a DAX formula to calculate the sum of the previous quarter revenue and multiply that total by 4?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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 

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.