Forum Discussion
Customers with no SALES, using time intelligence parameter
Hello dear community,
I need to create one comparison of NO SALES customers. I found this article, however, we don´t have date table in my schema, we work with the "time intelligence" parameter of powerbi Desktop, who automatically creates date hierarchy.
https://www.daxpatterns.com/comparing-different-time-periods/
It would work? Does anyone have another suggestion?
Best Regards,
Bruno
Hi brunozanoelo - If you don't have a dedicated date table and rely on Power BI's auto-generated date hierarchy, you can still compare "No Sales" customers over different periods, but it might be more limited and less flexible. The auto-generated date hierarchy works for simple time intelligence functions, but for more advanced scenarios like comparing "No Sales" customers, a dedicated date table is usually recommended.
You can use DATEADD, PARALLELPERIOD, or other time functions, but they rely on a proper date column.
Make sure your date column in the sales table is in date format and that the auto date/time feature is enabled.Auto date/time in Power BI Desktop - Power BI | Microsoft Learn
Design guidance for date tables in Power BI Desktop - Power BI | Microsoft Learn
4 Replies
Hi brunozanoelo - If you don't have a dedicated date table and rely on Power BI's auto-generated date hierarchy, you can still compare "No Sales" customers over different periods, but it might be more limited and less flexible. The auto-generated date hierarchy works for simple time intelligence functions, but for more advanced scenarios like comparing "No Sales" customers, a dedicated date table is usually recommended.
You can use DATEADD, PARALLELPERIOD, or other time functions, but they rely on a proper date column.
Make sure your date column in the sales table is in date format and that the auto date/time feature is enabled.Auto date/time in Power BI Desktop - Power BI | Microsoft Learn
Design guidance for date tables in Power BI Desktop - Power BI | Microsoft Learn
Hi brunozanoelo,
Also, thanks to rajendraongole1 for the prompt and helpful response.
we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
Regards,
Prasanna KumarHi brunozanoelo,
We wanted to kindly check in to see if everything is working as expected after trying the suggested solution. If there’s anything else we can assist with, please don’t hesitate to ask.
If the issue is resolved, we’d appreciate it if you could mark the helpful reply as Accepted Solution — it helps others who might face a similar issue.
Warm regards,
Prasanna Kumar
Hi brunozanoelo,
Just a gentle reminder — has your issue been resolved? If so, we’d be grateful if you could mark the solution that worked as Accepted Solution, or feel free to share your own if you found a different fix.
This not only closes the loop on your query but also helps others in the community solve similar issues faster.
Thank you for your time and feedback!
Best,
Prasanna Kumar
