Revenue for the year end assuming 1% decline on a month on month basis

[Noman]

Revenue for the year end assuming 1% decline on a month on month basis

[Ashish_Mathur]

Hi,

Do you actually think writing just a sentence as a question is enough information for someone to help you?  Share some data, explain the question and show the expected result.  Paste data in a format that can be copied to an MS Excel file.  Alternatively, share the download link of the PBI file.

[amitchandak]

@Noman , Try a measure like

sumx(Values('Date'[Month Year])CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],(-1*month(Today()))+1,MONTH)))*POWER( month(Max('Date'[Date])) -1,.9))

[Noman]

Its not working