How to Count Customers Converted in Last 90 Days in Current Date

[shanipowerbi]

Hi Expert 

I hope you are fine, I was using the below formula to calculate Customer converted in 90 Days in Current Date and till last month it was working very fine, but suddenly its stop working and giving wired result.

Customers (Converted in 90 Days) = CALCULATE([Current Active User], DATESINPERIOD('Active Users Data'[User with Conversion Data.ConversionDate], LASTDATE('Active Users Data'[User with Conversion Data.ConversionDate]),-90, DAY))

My Columns are

Calender Date / User IDs / Convertions Date

I have calculated the Number of Active users with Calculate (DistinctCount(User ID)).

Please help me to resolve this issue and please help me to understand why the above formula not working now.

Regards

Zeeshan

[v-diye-msft]

Hi @shanipowerbi 

you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive for business and share the link to the file. that will be easier for us to do deep research.

[amitchandak]

@shanipowerbi , prefer to do this with a date calendar

Customers (Converted in 90 Days) = CALCULATE([Current Active User], DATESINPERIOD(Date[Date], LASTDATE('Active Users Data'[User with Conversion Data.ConversionDate]),-90, DAY))

Or
Customers (Converted in 90 Days) = CALCULATE([Current Active User], DATESINPERIOD(Date[Date], Max('Active Users Data'[User with Conversion Data.ConversionDate]),-90, DAY))

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 :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

[shanipowerbi]

Not Worked, Same problem, not getting every day last 90 days converted customer numbers.

Thanks for the effort