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 want to build a DAX formula that can calculate sales between two dates, 1 date is static that is end date, and 1 date is what I will let user pass and the formula should generate the balance as per that date for any given period, currently I am using below but it do not gives me exact results when I compare this to my SAP System, wondring what I have done wrong here.
Solved! Go to Solution.
Hi @Anmolgan ,
Please give a try to below measure:
Measure = CALCULATE ( SUM ( ValueTable[Value] ), FILTER ( ValueTable, ValueTable[Date] >= MIN( PeriodTable[StartDate] ) && ValueTable[Date] <= MAX ( PeriodTable[EndDate] ) ) )
Please give KUDOS for support and also mark this as a solution if it helps you!
Hi @Anmolgan ,
Can you please share some sample data with minimum table structure and expected result for test? it is hard to coding formula without any detail information.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Hi @Anmolgan ,
Please give a try to below measure:
Measure = CALCULATE ( SUM ( ValueTable[Value] ), FILTER ( ValueTable, ValueTable[Date] >= MIN( PeriodTable[StartDate] ) && ValueTable[Date] <= MAX ( PeriodTable[EndDate] ) ) )
Please give KUDOS for support and also mark this as a solution if it helps you!
Good answer, but would like to know this:
How is ValueTable related to PeriodTable?
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |