Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

YoY Quick Measure - Date Issue

Hello, I am trying to calculate Sales $ year over year change. I have my data by year however, the app will not allow me to add any data into the date field. I have read multiple articles and the...

6 years ago

Hi Anonymous ,

Try measure like this:

Measure =
VAR year =
    MAX ( 'Table'[year] )
VAR last_year_sale =
    CALCULATE (
        FIRSTNONBLANK ( 'Table'[sales], 1 ),
        FILTER ( ALLEXCEPT ( 'Table', 'Table'[vendor] ), 'Table'[year] = year - 1 )
    )
RETURN
    DIVIDE ( MAX ( 'Table'[sales] ), last_year_sale )

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

aj1973
6 years ago
Sorry guys the Divide formula must be looking like this

Sorry again
Regards

Anonymous

Not applicable

6 years ago

Hello,

ryan_mayu thank you for your help. My data is summarizing the Vendor # by Year. I can not have the date by month as it will be too many rows. I have an excel doc that caclculates YOY calculations and I am trying to the same in Power BI.

Super User

6 years ago

Anonymous

I create a sample data.

Then you create measures to calculate last year value and YOY%

Related content