Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

DAX

I have a Production table, DimDate table. I needed to display weekly sum which I was able to do using SUMMARIZE function. Output of SUMMARIZE function is in 'TableS' with 2 columns WeekNo, SumP.  Now...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Yeah updated picture of data.

parry2k's avatar
parry2k
Super User
7 years ago

Anonymous just to confirm, is this what you are looking for? I Just did two weeks

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Yes correct. You got it what I am trying to do.

    • parry2k's avatar
      parry2k
      Super User
      7 years ago

      Anonymous  add following as a measure

       

      SumP = 
      SUMX( 'DimDate', 
      	IF( 'DimDate'[Day] = 7, 
      		CALCULATE( 
      			SUM( Table1[Production] ) , 
      			ALLEXCEPT( 'DimDate', 'DimDate'[WeekNo] ) 
      		)  
      	) 
      )