Forum Discussion
Helper IIItotalmtd pre month
Help me please! Suppose today is November 23rd, a client handed over to me a batch of products throughout October (the last date of delivery is 10/28/21), as well as in July, several deliveries. How can I calculate the total of deliveries for October and July and, on the basis of this, make a conclusion that his deliveries have increased compared to July or not?
Users Data Sales
ООО Чароит 28.10 19
ООО Чароит 25.10 60
ООО Чароит 23.10 139
ООО Чароит 18.10 169
ООО Чароит 9.10 129
ООО Чароит 27.7 1384
ООО Чароит 13.7 419
ООО Чароит 8.7 2404
ООО Чароит 5.7 2215
ООО Чароит 1.7 1
Hi DeEviloN ,
I created a sample pbix file(see attachment), please check whether that is what you want. You can create a measure as below to get the totalmtd:
MTD = TOTALMTD(SUM('Table'[Sales]),'Date'[Date])In addition, you can refer the following blogs to get it.
Calculating MTD, QTD, YTD, Running and Cumulative Total in Power BI
Best Regards
2 Replies
DeEviloN
Date table I haveHi DeEviloN ,
I created a sample pbix file(see attachment), please check whether that is what you want. You can create a measure as below to get the totalmtd:
MTD = TOTALMTD(SUM('Table'[Sales]),'Date'[Date])In addition, you can refer the following blogs to get it.
Calculating MTD, QTD, YTD, Running and Cumulative Total in Power BI
Best Regards