Forum Discussion

SteelChampzz's avatar
SteelChampzz
Helper II
3 years ago
Solved

Same Period Last Month using working days

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 Lin...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    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's avatar
SteelChampzz
Helper II
3 years ago

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's avatar
v-yanjiang-msft
Community Support
3 years ago

Hi SteelChampzz ,

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

Best Regards,
Community Support Team _ kalyj