Power BI - Previous Workday's Performance

[Buck2919]

Hi,

I'm pretty new to PowerBI so please bear with me.

I've created a report and i want a simple matrix to show the previouse days performance.

I have created two measures

1) Total items worked - Total Classified = COUNTx(TOM_DATA,TOM_DATA[Investigation Classification])
2) Previous Days perfomance - Previous Day Classified = CALCULATE([Total Classified],DATEADD(Rolling_Calendar[Date],-1,DAY))

However my matrix has gaps in it.

Simply i want to return Fridays performance next to Monday's performance in my Matrix.

Please can anybody help!

Thanks in advance Michael

 

[JustynaMK]

Hi Michael,

Maybe try something like that -

Previous Day Classified = 
    var MaxDate = MAXX(FILTER(ALL(Rolling_Calendar), Rolling_Calendar[Date] < SELECTEDVALUE(Rolling_Calendar[Date])), Rolling_Calendar[Date])
return
    CALCULATE(
        [Total Classified],
        FILTER(ALL(Rolling_Calendar), Rolling_Calendar[Date] = MaxDate)
    )

 

[Buck2919]

Hi JustynaMK

Thank you so much for your response.

However it doesn't quite solve my problem. - The second column below is the returned data from your code and doesn't move Friday's classified DATA to the next working day i.e. Monday.

We don't work weekends to i need to exclude them and show the previous working day in the matrix - Example - Fridays 27th March's data in the first column should show in the second column on Monday 30th March and not in Saturday 28th March.

Thank you so much for you help i really appriciate it and hopefully you can find me a solution.

Kind Regards
Michael

 

[JustynaMK]

Ahh of course! ?‍

How about this one -

Previous Day Classified = 
    var MaxDate = MAXX(
        FILTER(ALL(Rolling_Calendar), Rolling_Calendar[Date] < SELECTEDVALUE(Rolling_Calendar[Date]) && NOT ISBLANK([Total Classified])), 
        Rolling_Calendar[Date])
return
    IF([Total Classified] <> 0,
    CALCULATE(
        [Total Classified],
        FILTER(ALL(Rolling_Calendar), Rolling_Calendar[Date] = MaxDate)
    ))

 

[Buck2919]

Oh wow!

That is absolutely perfect - Thank you so much.

 

[JustynaMK]

You're most welcome