DAX for counting rows in same period current year and previous year.

[Anonymous]

I have a table with all the social media posts made by my company for the last two years.  Wanting to get a new measurement that shows the number made YTD  and then another that shows the amount for same period last year.   I can get the current year,  but previous year won't work.  

YTD Posts = CALCULATE(DISTINCTCOUNT('Social Performance'[Post ID]),DATESYTD('Social Performance'[Date],"12/31"))

LY Posts = CALCULATE(DISTINCTCOUNT('Social Performance'[Post ID]),DATESYTD(DATEADD('Social Performance'[Date],-1,Year),"12/31"))

Working to graph these by week,  where the week is based in a date table.  This is connected to date table by similar date.   

Appreciate any help.  Thanks.  

[Sahir_Maharaj]

Hello @Anonymous,

Can you please try this:

1. Current Year YTD Posts Calculation

YTD Posts = CALCULATE(
    DISTINCTCOUNT('Social Performance'[Post ID]),
    DATESYTD('Social Performance'[Date], "12/31")
)

2. Previous Year YTD Posts Calculation

LY Posts = CALCULATE(
    DISTINCTCOUNT('Social Performance'[Post ID]),
    SAMEPERIODLASTYEAR(DATESYTD('Date'[Date], "12/31"))
)

[Anonymous]

The LY Posts is showing CUMULATIVE by week, when I want it to show by week.  The YTD Posts works correctly.