Help please! Operating with values in one column (for different months)

[Anonymous]

Hi Community!

I'm new here, and I would very much appreciate if you can help me with this (probably simple) situation.

I have a table that looks like this:

And I need to show a visualization like this one:

Without creating another table that transposes the data, is there a way to calculate the fields in the second table using DAX?

I´ll make sure to thank with points the solving solution and even post a thank you note in LinkedIn.

Thank you all in advance,

Best regards!

[Anonymous]

@tamerj1 Thank you very very much!! It worked perfectly! 

I can´t believe you even sent me a sample file with the solution.

I appreciate it.

Best regards!

[tamerj1 · Accepted solution]

Hi @Anonymous 
Here is a sample file with the solution https://we.tl/t-209bVq49gJ

Salaies = 
VAR CurrentValue = SUM ( Payroll[salary] )
VAR MinDate = CALCULATE ( MIN ( Payroll[dim_time] ), ALLSELECTED ( Payroll ) )
VAR MaxDate = CALCULATE ( MAX ( Payroll[dim_time] ), ALLSELECTED ( Payroll ) )
VAR FirstValue = CALCULATE ( SUM ( Payroll[salary] ), Payroll[dim_time] = MinDate )
VAR LastValue = CALCULATE ( SUM ( Payroll[salary] ), Payroll[dim_time] = MaxDate )
RETURN
    IF (
        HASONEVALUE ( Payroll[dim_time] ),
        CurrentValue,
        FORMAT ( DIVIDE ( LastValue - FirstValue, FirstValue ), "Percent" )
    )