Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

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 visu...
  • tamerj1's avatar
    tamerj1
    4 years ago

    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" )
    )

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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!