Forum Discussion

JBI's avatar
JBI
Frequent Visitor
7 years ago

Difference between two points

Hi Guys,   I have data that is not transactional. Each entry is the current value for that month. Thus it's not data such as sales that can be summed but rather a single value at a point in time. ...
Need Help
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi JBI ,

For your requirement, you could refer to the measure below. You could modify it based on your scenario.

Measure =
VAR c_m =
    CALCULATE (
        SUM ( 'Sales'[Project Sales] ),
        FILTER (
            'Calendar',
            'Calendar'[Month] = MAX ( 'Sales'[Month] )
                && 'Calendar'[Date].[Year] = MAX ( 'Sales'[year] )
        )
    )
VAR c_m_6 =
    CALCULATE (
        SUM ( 'Sales'[Project Sales] ),
        DATEADD ( 'Sales'[Date_column], -6, MONTH )
    )
RETURN
    c_m - c_m_6

Here is the output.

For more details, please refer to my attchment.

Best  Regards,

Cherry