Sales for this year and last year

[sixtoquiles]

HI I need to a solution, I wanna to count how record are from january-2016 to today() minus one year.

Example:

Today-1year = 8/11/2016

Count record from 1/1/2016 to 8/11/2016

[MFelix]

Hi @sixtoquilles,

Add this measure

PY = TOTALYTD ( COUNT(Table[Record]), Dateadd(Today(), -1,YEAR)

If you want to make the date based on a date in a column replace the TODAY() bt that column name.

Regards,
MFelix

[mattbrice]

---

@MFelix wrote:
@Hi @sixtoquilles,

Add this measure

PY = TOTALYTD ( COUNT(Table[Record]), Dateadd(Today(), -1,YEAR)

If you want to make the date based on a date in a column replace the TODAY() bt that column name.

Regards,
MFelix

---

Sorry, but I dont' think the above will work as both 'DATEADD' and 'TOTALYTD' require an actual column reference.

If you have a best practice 'Calendar' table you can do this:

PY =
TOTALYTD ( COUNT ( Table[Column] ), SAMEPERIODLASTYEAR ( Calendar[Date] ) )