Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Visualization: YTD target vs YTD actual

I've got a table with dates and sales, it's connected to CRM online which will be auto refreshed.   i've created a "Gauge" dashboard with Max (Year Target) and Target (YTD Target)   t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

v-caliao-msft if the target table is like below, what's the DAX to get YTD target and TODAY's target.  For example, if today 30/01/2017. i would like YTD = 22+22+22+0+0+0+0=66,  and TODAY's target = 0.

 

thanks

Anonymous's avatar
Anonymous
Not applicable
9 years ago

any1 know? thanks.