Sum based on week number and location

[BReetz]

Hi All,

I am completely new to PBI and am self teaching.  I am trying to add a column to my data set that calculates the percent of positive tests by week number and location so somehow need to subtotal the new tests and new cases by week.  I am able to calculate that percentage on a daily basis, but can't quite get it to subtotal by week.  Any suggestions would be greatly appreciated!

[amitchandak]

@BReetz , Refer if this blog can help

https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[lbendlin]

you have a weeknumber column but it doesn't say what it relates to. Do you have a year column too?

[BReetz]

I have a separate date table that includes columns for date, year, month name, month number, quarter number and week number.

[lbendlin]

put your facts into the values area of the matrix visual and the week number in the rows or columns.