Cumulative Count in Power BI

Question

I had an email data and I am trying to add in the dashboard, For example

1-Jan open

2-Jan open

2-Jan click

2-Jan open

3-Jan click

4-Jan open

and running count look like this

1-Jan 1

2-Jan 3

3-Jan 3

4-Jan 4

is there anyway to add the data into the dashboard? 

Answer 1

Use the following DAX equation

Running Count = TOTALYTD ( COUNTROWS ( 'My Table' ) , 'My Table'[My Date] )

Interested to Learn Power Bi in detail? Come and Join the Power BI course by Intellipaat.

Check the following youtube link: