TOTAL QUARTER

[Anonymous]

HELLO, I NEED SUM THE TOTAL QUARTER, FOR EXEMPLE, I HAVE 12 MONTHS AND NEED (ALWAYS) SUM JUST THE LAST QUARTER.

1,2,3,4,5,6,7,8,9,10,11,12

SUM 123

SUM 456

SUM 789

SUM 101112

IF THERE IS 1,2,3,4,5,6, CONSIDER (SUM) JUST THE ONLY 4,5,6.

THANKS!

[VahidDM · Accepted solution]

Hi @Anonymous 
Try this measure:

Total last Quarter = 
var _LQ = QUARTER(LASTDATE('Table'[Date]))
return
SUMx(filter('Table',QUARTER('Table'[Date])=_LQ),'Table'[Value])

Output:

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

Appreciate your Kudos ✌️!!

[Anonymous]

Great @VahidDM thanks you so much!

[Anonymous]

The actual format is DD/MM/YYYY, it was createda function TOTALQTD(SUM(numer1), date)), believe that that TOTALQTD be the function for sum the quarter!

[amitchandak]

@Anonymous , is this actual data format?

Can you share sample data and sample output in table format?