Measure value over previous value

[ero]

Hi, 

As a new Power Bi user I really would appreciate your help. I need a Measure that will give me the previous value ( year or quarters) based on the same column. I've tried different suggestions found on the forum, but haven't been able to figure it our. I think the problem has to do with having two slicers (one for items selected and another for date). Here iis an example of what I'm using.

Thanks

[v-jiascu-msft]

Hi @ero ,

They are two different items. Why should the value of [Item 1] return for [Item 2 Sur]? What if there are many many items?

Are there any duplicates? For example, a record similar to line 5 like this: 1, 10/2/2015, Item 1, 2015 4T, 0.411. Then which value should return, 0.417 or 0.411?

Best Regards,

[ero]

Hi,

I found the real problem I'm having.  If I put the Date column in my slicer then I can use 

Previous Year = CALCULATE(SUM(Table[Value]), SAMEPERIODLASTYEAR(Table[Date]))

Doing so will show the desired value, but the date format  I get in the slicer is not what I want. It will show 1/1/2005 but I need the format that appears in the Quarter column which is a text format (2005 1T). I tried changing this using field in Visualization and selecting Date hierachy, but I only get year as an option and nothing more.

Do you know a way I can solve this?

[v-jiascu-msft]

Hi @ero ,

We can use the Quarter column in a slicer. It's better to have a date related column in the target visual in which the measure [Previous Year] is. 

Can you share some snapshots? Please mask the sensitive parts.

Best Regards,