Measure Visualization by Week

[Anonymous]

Hello,

I have a measure showing the value in a visualization like this: 

Overdue = CALCULATE(COUNT(Table[Overdue]), Table[Overdue] = "overdue") + 0

The table that this measure draws from has various date columns that I think would be involved in my answer.

What I would like to show is this measure's value, but how it changes by week, like this:

Is there any way that I can do this? I have thought about adding a table that contains a list of dates then tying it to the parent table someway, but I am unsure if that would work or if there is a better solution.

Thank you

[amitchandak]

@Anonymous , Typically Overdue is as on date. If it can work with past dates. Then you can have a date table and create a Week Number like

Week ="WW" & Week Number = WEEKNUM([Date],2) //Monday Week

Week ="WW" & Week Number = WEEKNUM([Date]) //SundayWeek

Or like

Week Number =WEEKNUM([Date],2)

Week  = "WW" & if('Date'[Week Number]<10,'Date'[Year]*10 & 'Date'[Week Number],'Date'[Year]&'Date'[Week Number])

[MarcoPessina]

Hi @Anonymous,

you can achieve it adding a Date table, creating a relationship with your table and using the measure you have created.

Try this:

https://1drv.ms/u/s!AqOXkXXQjzm4bYGECHgAE1jhqgc?e=IV1FKv

Hope it helps.

Cheers,

Marco

[Anonymous]

Hello Marco,

Whenever I try to open your file I get an "Object reference not set to an instance of an object" error

Thanks for helping

[MarcoPessina · Accepted solution]

Hi @Anonymous ,

It could be related to your Power BI version.

Mine is: 2.80.5803.1061 64-bit (April 2020)

I've just downloaded the file and opened it without problems.

Can you try using the latest version?

Cheers,

Marco