Compare Actual Result with Target and Last Year result in a visual

SilviuIL — Thu, 15 Oct 2020 11:29:50 GMT

Hi guys,

I am having difficulties in creating a visual that compares Actual Result with Last Year result and Target.

In the visual below i want to add a 3rd line that will show the target value:

Actual Result is calculated measure from a table with data at Day Level, that looks like this

and I have a separate table for Targets at Month Level with no relation between them:

Can you please help with a solution?

Thanks

Re: Compare Actual Result with Target and Last Year result in a visual

amitchandak — Thu, 15 Oct 2020 12:31:51 GMT

SilviuIL , Create a date in the target table

Date = date([year], [month],1)

Date = eomonth(date([year], [month],1),-1)

Join your actual and target with a date table and use that to plot time/date

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.

topic Compare Actual Result with Target and Last Year result in a visual in DAX Commands and Tips

Compare Actual Result with Target and Last Year result in a visual

Re: Compare Actual Result with Target and Last Year result in a visual