Forum Discussion

Fatman121's avatar
Fatman121
Frequent Visitor
4 years ago

Calculate total between matrix headers

Hi!   I have matrix. It is looks like this:   date date1 date1 date2 date2 branch Sales Count_of_sales Sales Count_of_sales branch1 Measure1 Measure2 Measure1 Measure2 Bra...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Fatman121 ,

Please have a try.

Create a calendar date table first.

date=calendar(date(2021,1,1),date(2022,12,31))

Then put the date column into the slicer.

 

Then create a measure.

measure=var _selemindate=selectedvalue('table'[date])
var _selemax=selectedvalue('date'[date])
return
calculate(sum('table[value]),filter(all('table'),'table'[order]=selectedvalue('table'[order])&&'table'[date]>_selemindate&&'table'[date]<=_selemax))

 

If I have misundetstood, please provide more details with your desired output and some sample data.

 

How to Get Your Question Answered Quickly 

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.