Forum Discussion
Measure value over previous value
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
3 Replies
Hi Anonymous ,
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,
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?Hi Anonymous ,
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,
