Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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 ...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

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,

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      v-jiascu-msft
      Microsoft Employee
      7 years ago

      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,