Forum Discussion
Solved
comparation today
Deaer All,
Can Any body help me?
How I can get the total sales of a month (from 1 st day to end of month)
how can i get end of month date (31 Jan, 28 Feb, 31 March, 30 Apr , etc....)
Thankyou for helping me
Rgds
Aji
Please check if this is what you want.
Measure 2 = var MAXDATE=MAX('sales'[tanggal]) RETURN CALCULATE(SUM(sales[sales]),FILTER(sales,MONTH(sales[tanggal])=MONTH(MAXDATE)-1&&YEAR(sales[tanggal])=YEAR(MAXDATE))) Measure 3 = var MAXDATE=MAX('sales'[tanggal]) RETURN CALCULATE(SUM(sales[sales]),FILTER(ALL(sales),MONTH(sales[tanggal])=MONTH(MAXDATE)&&YEAR(sales[tanggal])=YEAR(MAXDATE)-1))
6 Replies
Ajeck Would need sample source data as text and expected output to be 100% but, you can get the end of any month like this:
End of Month = EOMONTH([Date],0)Thank you for helping me, I used this : End of Month = EOMONTH('Invoked Function'[Date],0) then I make a card visualitation, but it dint't work.
What should I do?
Rgds
AJeck
