cancel
Showing results for
Did you mean:
Impactful Individual

## How to make my YTD Qty display as 176 ?

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

1 ACCEPTED SOLUTION
Community Support

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

Create the measure:

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.

3 REPLIES 3
Community Support

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

Create the measure:

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.

Super User IV

You simply use the formula as follows:

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

Did I answer your question? Mark my post as a solution! and hit thumbs up

Solution Supplier

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.

Announcements

#### 2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.