topic Re: Sum based on week number and location in DAX Commands and Tips

Sum based on week number and location

BReetz — Wed, 01 Jul 2020 13:32:50 GMT

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!

Re: Sum based on week number and location

lbendlin — Wed, 01 Jul 2020 13:37:55 GMT

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

Re: Sum based on week number and location

amitchandak — Wed, 01 Jul 2020 13:48:11 GMT

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-Last-Week/ba-p/1051123

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

Re: Sum based on week number and location

BReetz — Mon, 06 Jul 2020 13:49:54 GMT

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

Re: Sum based on week number and location

lbendlin — Mon, 06 Jul 2020 15:35:55 GMT

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