Value of previous row with discontinuous dates (on the same row)

[Anonymous]

Hi

I have a simple Sales table connected to a Calendar table. The Sales table has a "Paiement Date" column connected to the Calendar table.

I have a matrix displaying Years/Months Name with the Total Sales for each Month (a simple sum!).

I'm looking how to retrieve at each Month visible row the value of the previous know under the following constraints:

• The Months are discontinuous (sometimes no sales during 3-4 months)
• No new rows should appear when adding the DAX measure as a new column in the matrix

Thanks for your help.

[Anonymous]

Hello try to use calculate([your measure],previousmonth([date])

[Anonymous]

Because the Months are discontinuous your solution doesn't work as it adds new rows (doesn't satisfy my constraint #2).