Forum Discussion
Solved
Seeking Help for Running Total Measure
Hi Experts, I seek for help as follows: 1) To count for Returned status for every week of each month. 2) Running total measure for accumulative return for the returned status above. Expecte...
Hi Zaky ,
You could get the result by following steps but you couldn't get the same visual if you are using two measures.
Create columns.
Week = var currentweek=WEEKNUM('Table'[Month of Return],1) var startWeek=WEEKNUM(DATE('Table'[Month of Return].[Year],'Table'[Month of Return].[MonthNo],1),1) return "week"&Currentweek-startWeek+1 month = FORMAT('Table'[Month of Return],"MMM")Create measures.
Measure = COUNTROWS('Table') Measure 2 = CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),'Table'[Month of Return]<=MAX('Table'[Month of Return])))Result would be shown as below.
Best Regards,
Jay
Hi Zaky ,
You could get the result by following steps but you couldn't get the same visual if you are using two measures.
Create columns.
Week =
var currentweek=WEEKNUM('Table'[Month of Return],1)
var startWeek=WEEKNUM(DATE('Table'[Month of Return].[Year],'Table'[Month of Return].[MonthNo],1),1)
return
"week"&Currentweek-startWeek+1
month = FORMAT('Table'[Month of Return],"MMM")Create measures.
Measure = COUNTROWS('Table')
Measure 2 = CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),'Table'[Month of Return]<=MAX('Table'[Month of Return])))Result would be shown as below.
Best Regards,
Jay