topic KPI Target YTD with Live Dataset in DAX Commands and Tips

KPI Target YTD with Live Dataset

Anonymous — Wed, 11 Aug 2021 09:57:10 GMT

Hi,

I'm trying to format some KPIs, I have a monthly goal of '22' and it is fixed at 22 per month for the year. How do I write the DAX for YTD goal whereby my report shows the previous months goal within the KPI? I.e. When it turns february, it shows as 22, March is 44, April 66 etc..

I created a new measure simply as 'Prop = 22' so that if the target changes next year I can rename the variable to say 'Prop = 24' and the YTD will change with it.

Having trouble as I am new to Power BI and using a live dataset, thanks!

Re: KPI Target YTD with Live Dataset

Anonymous — Wed, 11 Aug 2021 11:33:55 GMT

Yeah... sure. How to Get Your Question Answered Quickly - Microsoft Power BI Community

Re: KPI Target YTD with Live Dataset

VahidDM — Wed, 11 Aug 2021 12:03:23 GMT

Hi Anonymous

Well, your question is not clear, but if you want to calculate the KPI based on the Today Date, you can use the below code:

KPI= VAR _Month_Goal = 22 // Monthly Goal RETURN VAR _Date = TODAY () // you can change this to any date RETURN VAR _MonthP = MONTH ( _Date ) // this Var shows the month of the _Date RETURN ( _MonthP - 1 ) * _Month_Goal

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos !!

Re: KPI Target YTD with Live Dataset

Anonymous — Wed, 11 Aug 2021 14:25:15 GMT

Ah yes thats great! Thanks VahidDM