HI I need to a solution, I wanna to count how record are from january-2016 to today() minus one year.
Today-1year = 8/11/2016
Count record from 1/1/2016 to 8/11/2016
Proud to be a Datanaut!
@MFelix wrote:@Hi @sixtoquilles,Add this measurePY = 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:
TOTALYTD ( COUNT ( Table[Column] ), SAMEPERIODLASTYEAR ( Calendar[Date] ) )
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!