Forum Discussion
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 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!
Hi Anonymous
Here is a sample file with the solution https://we.tl/t-209bVq49gJSalaies = 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" ) )
2 Replies
Hi Anonymous
Here is a sample file with the solution https://we.tl/t-209bVq49gJSalaies = 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" ) )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!