cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
snifer Member
Member

calculate measure to put in matrix

yearmonthamountcodecompany 
201711000101dd 
201723000101dd 
201737000101dd 
2017410000101dd 
2017514000101dd 
2017618000101dd 
2017725000101dd 
2017830000101dd 
2017940000101dd 
20171075000101dd 
20171195000101dd 
201712100000101dd 
201812000101dd 
201823000101dd 
201835000101dd 
201847000101dd 
2018510000101dd 
2018612000101dd 
2018715000101dd 
2018819000101dd 
2018930000101dd 
20181040000101dd 
20181145000101dd 
20181250000101dd 
201711000102dd 
201723000102dd 
201737000102dd 
2017410000102dd 
2017514000102dd 
2017618000102dd 
2017725000102dd 
2017830000102dd 
2017940000102dd 
20171075000102dd 
20171195000102dd 
201712100000102dd 
201812000102dd 
201823000102dd 
201835000102dd 
201847000102dd 
2018510000102dd 
2018612000102dd 
2018715000102dd 
2018819000102dd 
2018930000102dd 
20181040000102dd 
20181145000102dd 
20181250000102dd 
201711000101hh 
201723000101hh 
201737000101hh 
2017410000101hh 
2017514000101hh 
2017618000101hh 
2017725000101hh 
2017830000101hh 
2017940000101hh 
20171075000101hh 
20171195000101hh 
201712100000101hh 
201812000101hh 
201823000101hh 
201835000101hh 
201847000101hh 
2018510000101hh 
2018612000101hh 
2018715000101hh 
2018819000101hh 
2018930000101hh 
20181040000101hh 
20181145000101hh 
20181250000101hh 
201711000102hh 
201723000102hh 
201737000102hh 
2017410000102hh 
2017514000102hh 
2017618000102hh 
2017725000102hh 
2017830000102hh 
2017940000102hh 
20171075000102hh 
20171195000102hh 
201712100000102hh 
201812000102hh 
201823000102hh 
201835000102hh 
201847000102hh 
2018510000102hh 
2018612000102hh 
2018715000102hh 
2018819000102hh 
2018930000102hh 
20181040000102hh 
20181145000102hh 
20181250000102hh 

 

This is may data in the table

 

i need to make a measure that will calculate>

 

for month 1 year "2018" the company "dd" the sum of the "amount" for the code "101" and "102"

 

keep in mind that i need the month and year and company to be dynamic, meaning that these gonna chnage based on month and yar and company I do need to calculate at moment.

 

example result= amount( code101 for month x and year xcompany z)+amount(code 102 for month x and year xcompanz)-> same month and year fand company for both code

 

month and year  companywill be filtered in powerbi dashboard

i want to buil a matric where column will be onth of the year and it will be selecting year and company

 

               company selector year 
               hh  2018 
 123456789101112       
sum calculated both code                   
                    
                    
                    
1 REPLY 1
Community Support Team
Community Support Team

Re: calculate measure to put in matrix

Hi @snifer,

 


 

example result= amount( code101 for month x and year xcompany z)+amount(code 102 for month x and year xcompanz)-> same month and year fand company for both code

 


Sorry I cannot get you. What is your excepted reuslt then? 

 

Regards,

Frank


 

 

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