How to make my YTD Qty display as 176 ?

[admin11]

Hi All

I have a expression which compute YTD Qty sold. 

Sales YTD QTY =

var _max = today()

return

calculate(TOTALYTD(sum('SALES'[quantity]),'Date'[Date]),filter('Date','Date'[Date]<=_max))

Above expression seen correct , but not sure why it not return 176 ?

My PBI file

https://www.dropbox.com/s/p5ce3p3juf2sux8/PBS_VER050%20SI_PM.pbix?dl=0

Paul

[v-xiaotang · Accepted solution]

Hi @admin11 

Not clear about the result you want, but if you want to make Sales YTD QTY display as quantity, try this:

Create the measure:

YTD test = calculate(SUM(SALES[quantity]),DATESYTD(DATEADD('Date'[Date],0,YEAR)))

 Hope this helps.

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy]

@admin11 

You simply use the formula as follows:

Sales YTD Qty = TOTALYTD(sum('SALES'[quantity]),'Date'[Date])

[sayaliredij]

Hi @admin11 

You can create the following formula for Total Quantity

Total Quantity = SUM(SALES[quantity])

and use this formule for YTD

Total Quantity YTD = 

    TOTALYTD([Total Quantity], 'Date'[Date].[Date])

Regards,

Sayali

If this post helps, then please consider Accept it as the solution to help others find it more quickly.