Forum Discussion

NJ81858's avatar
NJ81858
Icon for Helper IV rankHelper IV
3 years ago

Counting per Month

I am trying to calculate the number of occurances per month. The 'Data Date' field is the month that the data was pulled and the 'Redemption Date' is the date that I am trying to count the number of ...
Need Help
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi NJ81858 
It depends on the filter context of your viual. However, yoy may try

Redemption Count =
SUMX (
    VALUES ( 'CD Data'[Data Date] ),
    COUNTROWS ( CALCULATETABLE ( VALUES ( 'CD Data'[Redemption Date] ) ) )
)