Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a Table (Named OrderDateRanges) contained Date ranges that comprises columns [StartDate] and [EndDate].
While I have another table (Orders) that contain Columns [Order_date] and a [Sales_Measure].
I need a Dax function to filter all Sum of all Sales with respect of Order_Date lies with all Date ranges given in OrderDateRanges.
I have done it one single date range selected date by dax.
But Unable to find other solution.
Not nesseccarily Dax function. If it can be done by Power query so that will do to.
Hi @Mujahid ,
Could you please post some simple sample data and your desired result to have a test if possible? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Regards,
Daniel He
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |