Same Period Last Month using working days

[SteelChampzz]

I have a table set up where I'm using "Working days" for each month:

I want to be able to calculate "Same Period Last Month" while using the "working days"

And then setup the measure in a Line Chart to be able to compare each working day for each month.

My Working days are built into my "calendar table" already.

What would be the proper measures to use and how would I set this up on a line chart?

Also, can I set-up a mesure to find the different "ranges" between work days as well?

Thanks for any help

[v-yanjiang-msft · Accepted solution]

Hi @SteelChampzz ,

According to your description, I try my best to reproduce the sample.

Table:

Calendar:

The two tables are related with Date column. Then create a measure.

Same Period Last Month =
CALCULATE (
    MAX ( 'Table'[Value] ),
    'Calendar'[Work Day] = MAX ( 'Calendar'[Work Day] ),
    EOMONTH ( 'Calendar'[Date], 0 ) = EOMONTH ( MAX ( 'Calendar'[Date] ), -1 )
)

From the matrix visual can see, it get the correct result.

You can also use a line chart to display the result.

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SteelChampzz]

So when I write this measure it only returns 19 workings back instead of the 21 or 23 days per month

Did I go wrong somewhere with my measure?

[v-yanjiang-msft]

Hi @SteelChampzz ,

Please try to select the option "Show items with no data".

Best Regards,
Community Support Team _ kalyj

[SteelChampzz]

This is a great example! thank you
Also could I use this in a "Range" when it comes to working days?
For example:

Average amount between working days "1-10"