Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
Can you please provide the Dax formula to achieve the output from the below. Please find the below expression i am using as dax expression that is not working. In report used is production date and slicer as Record date.
Desired Result:
Solved! Go to Solution.
@Anonymous,
Change 7 with 8:
7 day average = CALCULATE ( SUM ( 'Procount Record Date'[Value] ), DATESINPERIOD ( 'Procount Record Date'[Date], LASTDATE ( 'Procount Record Date'[Date] ), -8, DAY ) ) / 7
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous,
Modify Measure like pattern below and check if it can meet your requirement:
Result = CALCULATE ( [GasProduction (Sum)], FILTER ( 'Procount Record Date', 'Procount Record Date'[RelatedColumn] IN VALUES ( Well[RelatedColumn] ) ), DATESINPERIOD ( 'Procount Record Date'[Date], LASTDATE ( 'Procount Record Date'[Date] ), -7, DAY ) ) / 7
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I am modifying the DAX expression as below. Can you please share the desired DAX expression where the output show as in 2nd screen shot.
@Anonymous,
Change 7 with 8:
7 day average = CALCULATE ( SUM ( 'Procount Record Date'[Value] ), DATESINPERIOD ( 'Procount Record Date'[Date], LASTDATE ( 'Procount Record Date'[Date] ), -8, DAY ) ) / 7
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |