Forum Discussion

Keha's avatar
Keha
Frequent Visitor
9 years ago
Solved

Cumulative Measure - Set static Start Date

Dear experts,   I have run into a problem revolving around cumulative measures and I was hoping that you would be able to assist. What I am trying to achive is to display a bouncerate change over t...
Need Help
  • Keha's avatar
    Keha
    9 years ago

    I think I got it to work with:

     

    Test1 = IF (

        MIN ( 'DateDimension'[Date] )

            <= CALCULATE ( MAX ( 'Table'[Date] ); ALL ( 'Table' ) ); 

    CALCULATE (

        SUM('Table'[Bounces])/SUM('Table'[Sessions]);

        DATESYTD( Datedimension[Date] ) ) 

    )

     

    Thank you anyways!! 

     

Keha's avatar
Keha
Frequent Visitor
9 years ago

I think I got it to work with:

 

Test1 = IF (

    MIN ( 'DateDimension'[Date] )

        <= CALCULATE ( MAX ( 'Table'[Date] ); ALL ( 'Table' ) ); 

CALCULATE (

    SUM('Table'[Bounces])/SUM('Table'[Sessions]);

    DATESYTD( Datedimension[Date] ) ) 

)

 

Thank you anyways!! 

 

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi Keha,

Do you resolve your issue? If it does, please mark the corresponding reply as answer, so other people will find solution easily. If it doesn't, please don't hesitate to ask.

Best Regards,
Angelia