Forum Discussion

JH's avatar
JH
Frequent Visitor
8 years ago

Help! Delete cumulated values by Month

Hello,      I created a revenue cohort in Power BI, looking like this (appr. recreation):   I successfully managed to cumulate my values, to get the cumulated revenue cohort. However the f...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi JH

Do you use stacked bar chart? Which columns/measures do you put in this visual and how they are created?

Could you show a real screenshot of Power BI visual?

 

Best Regards

Maggie

JH's avatar
JH
Frequent Visitor
8 years ago

Hey Maggie,

 

Thanks for you reply! 

 

No, I used a Matrix Table. As column, I used the measure "Months after Signup" and as rows " Cohort". The value is "cumulated internal revenue", calculated with the following DAX  Formula: 

 

All three Measures are in the same "Internal Revenue" table

 

Cohort is an added collumn created like the following:

Unfortunately, I cannot publish an actual screenshot :)