Forum Discussion
Same Period Last Month using working days
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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
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"
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?
Hi SteelChampzz ,
Please try to select the option "Show items with no data".
Best Regards,
Community Support Team _ kalyj