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

 

Similarly data will be for different weeks and sum needs to be done for every week but will be shown only on Saturday in SumP column which we can get by Day column after checking value equal to 7.

parry2k's avatar
parry2k
Super User
7 years ago

Anonymous  can you put it in a more readable format? 

  • 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.