Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
4 years ago
Solved

Sales Vari % can display on table but not chart ?

Hi All

I have a Table , it can display YTD and LYTD sales and Sales Vari % :-

When itry to plot the chart it can display YTD and LYTD :-

Now i try to plot the Sales Vari % only , it does not display . Can some one advise me where go wrong ?

 

Paul Yeo

 

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    In the Source, delete the Source_temp column.  Revise the Sales_YTD measure to:

    Sales LYTD = 
var _max = date(year(today())-1,month(today()),day(today()))
return
TOTALYTD([SALES_],dateadd('DATE'[Date],-1,year),'DATE'[Date]<=_max)

5 Replies

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      4 years ago

      Hi,

      In the Source, delete the Source_temp column.  Revise the Sales_YTD measure to:

      Sales LYTD = 
var _max = date(year(today())-1,month(today()),day(today()))
return
TOTALYTD([SALES_],dateadd('DATE'[Date],-1,year),'DATE'[Date]<=_max)