Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Please help me convert this SQL query from a legacy system into dax. I will be using the BETWEEN date slicer in Power BI with report_date. The report_date is dynamic in the legacy system. The SQL Query gets the repeat shoppers who made a purchase in the last 180 days. I am confused how to convert it to dax. This query is a different query from the last post.
Sample Power File with Data:
https://drive.google.com/file/d/1SHFMwz53srJg3pwjQI4a7grBMyOGS-Ph/view?usp=sharing
SQL Data:
@PowerBIET , I always prefer, we should take a problem and solve it Power BI way, then query
So for repeat, new, lost, and did not appear in the last few days, can be worked using the logic given below
Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/b...
Customer Retention Part 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retenti...
Customer Retention Part 4:Customers to Retain- Segment in 4 quadrant based on Margin % and Discount: https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-4-Customers-to-Retain-Segmen...
For rolling
Rolling Days Formula: https://youtu.be/cJVj5nhkKBw
Rolling Months Formula: https://youtu.be/GS5O4G81fww
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
64 | |
63 | |
52 | |
36 | |
36 |
User | Count |
---|---|
80 | |
71 | |
58 | |
45 | |
44 |