Reg: sum of Multiple selection of month values not equal for MTD,YTD,QTD

[adityapv]

Hi,

I have created MTD,YTD,QTD values.i have created table with mentioned values.when i select single month values are matching but when i select multiple months ex: january,february,march the values are going to display for march only not for sum of January,february,march.Please help me.

[v-yingjl]

Hi @adityapv ,

Not certain what is your expected output. When I create these measures in my side, the total value is correct:

Could you please consider more details about this issue like screenshots, sample file without sesentive information or expected output for further discussion?

Best Regards,
Community Support Team _ Yingjie Li

[adityapv]

Hi amit,

thanks for the reply.I have used same formulas while calulating mtd and ytd values.but when i select multiple months lets say january and february then instead of sum,i am getting only february values.please helpme out.

[amitchandak]

@adityapv , values will be displayed based on first or last date based on time intelligence function you used .

this will give three months

Sales = SUM(Sales[Sales Amount])

these will be based on march

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))

QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(('Date'[Date])))

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))

refer video 3,4,5 of this series

https://www.youtube.com/watch?v=OBf0rjpp5Hw&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=3

[adityapv]

Hi amit,

i am using matrix table now.I have selected jan,feb,march,as per selection data is displaying correctly but in the matrix total column its not displaying total sum its displaying only mar value.