Measure for Values in column for same period but previous Fiscal year

[cristianml]

Hi,

I need HELP to CALCULATE the same value but from PREVIOUS Fiscal year period for each category (Entity, SG, HEADS) that I have in the following columns:

I need this to compare in a visualization thru a clustered column chart and Matrix table.

Note: The FY starts in September but I think this is irrelevant and it can be performed using only the Period colum.

How can I do this ?

Any idea or trick  for this ?

Thanks !

[V-lianl-msft · Accepted solution]

Generally speaking, the SAMEPERIODLASTYEAR function can solve the problem. Please try.

Measure = CALCULATE(SUM('Table (2)'[Value]),SAMEPERIODLASTYEAR('Table (2)'[Period]))

[Ashish_Mathur]

Hi,

You are writing a calculated column formula in your Table.  Please write a measure in your visual.

[cristianml]

Hi @Ashish_Mathur ,

How is the measure I need to write in the visual ? 

[Ashish_Mathur]

I do not know what measure you are trying to write but you have to write a measure by clicking on Modelling > New measure.