Cumulative Sum of Measure

[Anonymous]

Hi,

I am at a loss when trying to calculate the cumulative sum of a measure. I have read multiple forum posts and googled DAX formulae, but I am unable to find a solution to my problem. Here is my data.

Budget Data (read from an excel file)

Calendar Table (Created this using DAX).  Providing a snapshot.

I created a relationship between Quarter of Year (Budget Data) to Quarter (Calender). This has a cardinality Many-Many.

The Ask: Find the cumulative budget for WeekNum of Quarter

I first created a measure to calculate the Budget for WeekNum of Quarter.

Budget for WeekNum of Quarter = DIVIDE(DIVIDE(SUM('Budget Data'[Budget for Quarter]), 3), 13)

Built a matrix having the WeekNum of Quarter as Rows, Quarter as Columns and the above measure as values.

I need to create a measure to find the cumulative budget for weeknum of quarter. I have tried various ways but I end up getting values which are same as the measure. Please help and many thanks in advance.

How I want the data to look like:

[Anonymous]

Hi,

I am at a loss when trying to calculate the cumulative sum of a measure. I have read multiple forum posts and googled DAX formulae, but I am unable to find a solution to my problem. Here is my data.

Budget Data (read from an excel file)

Calendar Table (Created this using DAX).  Providing a snapshot.

I created a relationship between Quarter of Year (Budget Data) to Quarter (Calender). This has a cardinality Many-Many.

The Ask: Find the cumulative budget for WeekNum of Quarter

I first created a measure to calculate the Budget for WeekNum of Quarter.

Budget for WeekNum of Quarter = DIVIDE(DIVIDE(SUM('Budget Data'[Budget for Quarter]), 3), 13)

Built a matrix having the WeekNum of Quarter as Rows, Quarter as Columns and the above measure as values.

I need to create a measure to find the cumulative budget for weeknum of quarter. I have tried various ways but I end up getting values which are same as the measure. Please help and many thanks in advance.

How I want the data to look like:

[v-frfei-msft]

Hi @Anonymous ,

Hope this third party bolg can help you.

https://www.mssqltips.com/sqlservertip/4841/calculating-mtd-qtd-ytd-running-and-cumulative-total-in-power-bi/