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

GilbertQ thanks, is there any way to replace 30/06 to "today", so i don't need to update this everyday?

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
9 years ago

Hi Anonymous, you could possibly create another Calculated Measure which will can then use a filter.


EG: 

Todays Total = CALCULATE([My measure],Filter('Dates','Dates'[Calendar Date] = NOW()))
  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    GilbertQ what's the expression should after "totalytd"?  thanks. 

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      9 years ago

      Hi there I think it should be the following:

       

      YTDBudgetRev = TOTALYTD([SumNet],'CalendarDate'[Date],ALL('CalendarDate'),"29/01")
      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        GilbertQthis is what i've got, but didn't bring correct value.