How to show 'Vs Target %' for the month based on Today

[SRobbo1990]

Hi all,

Currently I have a graph showing how the business is doing for the Month vs the Target for the month and the Year previous. Below this we have a Card showing the high level values. (See below)

Now the issue I'm having is that the Booking GBS figure is live in the sense that its up to today. The target obviously goes right up until month end. The 'Vs Target %' is taking the Bookings GBS figure and comparing it to the Target GBS figure at month end. What I've been asked to do is show the 'To date' figures and then compare them.

I've been able to create a measure that shows it on a daily basis;

But as soon as I put it on the card it reverts back to the -14.86% figure for the full month. 

Is there anyway I can get it to look at just today's 'Vs Target %' without moving away from using the MTD functions?

Thanks

[MAwwad]

Yes, you can create a measure that calculates the "Vs Target %" for the current day. Here's an example formula that you can use:

scssCopy code

Vs Target % (MTD) Today = VAR TodayDate = TODAY() VAR BookingsMTD = [Bookings GBS MTD] VAR TargetMTD = [Target GBS MTD] VAR TargetToDate = TargetMTD / DAY(TodayDate) * DAY(EOMONTH(TodayDate)) RETURN DIVIDE(BookingsMTD, TargetToDate) - 1

This formula uses the TODAY() function to get the current date, and then calculates the target figure for the current day based on the number of days in the month so far. The rest of the calculation is similar to the MTD calculation that you already have.

Once you have this measure, you can add it to the card visual alongside the other measures. It should show the "Vs Target %" for the current day rather than for the entire month.