Forum Discussion
Displaying Sign-Up Data
I have fixed my problem!
I created a Cumaltive Measure on the sign up table so when filtering by year on the logins it will show how many people were signed up to that ate
LDC20 , if you have signup date, you can join that with a date table. In the date table, you can have month, qtr and year. And yiu can analyze by that.
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
I have my calendar table and the chart is correct however it doesnt give the information I would like to present
For example, if I look at the month of June 2020, I want to know how many people have logged in (just for the month of June) while knowing how many people were signed up until end of June 2020.
If I deselect certain months the number obviosuly will remove those from the filter, which I dont want to do
I have fixed my problem!
I created a Cumaltive Measure on the sign up table so when filtering by year on the logins it will show how many people were signed up to that ate