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 ...
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,