Create a chart per week

[shraddha_psingh]

Hello All,

I am trying to create a chart for per week analysis. The source is excel file that contains the list of assets, asset status, Begin Date and End Date. The chart should tell the user the number of assets that are in particular status(active/inactive) in the user selected week. My problem is - if there is an asset that is in a status for more than one week, how should I show it in the chart for week over?]\

Thanks in Advance!

[v-cherch-msft]

Hi @shraddha_psingh

You may try to add a measure and drag the measure to Visual Level Filters to show the value as requested. For example:

Measure =
IF (
    DATEDIFF ( MAX ( Table[begin date] ), MAX ( Table[end date] ), DAY ) > 7,
    "Over Week"
)

Regards,

Cherie

[Greg_Deckler]

First, Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

That being said, I have created a couple of Quick Measures to deal with things like what you are talking about:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364

https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365

[shraddha_psingh]

Hi Greg,

Thank you for your reply! Apologies.. this is my first question to the forum. 

While using quick measure as suggested by you for open tickets, it got an error for [Date] as shown below - 

I created a new table for Dates using CalendarAuto() and created the releationship but no success. Is there anything I am missing?

https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364