Forum Discussion

SteelChampzz's avatar
SteelChampzz
Icon for Helper II rankHelper 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 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

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.

4 Replies

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Icon for Community Support rankCommunity Support
    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
      Icon for Helper II rankHelper II
      3 years ago

      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"

    • SteelChampzz's avatar
      SteelChampzz
      Icon for Helper II rankHelper 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
        Icon for Community Support rankCommunity Support
        3 years ago

        Hi SteelChampzz ,

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

        Best Regards,
        Community Support Team _ kalyj