Forum Discussion
amksnpower
3 years agoNew Member
Need Dax help
hi, I am having data from 2017 for claims. i need to do mature warranty calculation ( in Excel I use the Edate to get a back date based on that date will sum claims & divide by production to get...
- 3 years ago
Dear Community Team, thank you for the replay & DAX. will try & update you
Anonymous
3 years agoNot applicable
Hi amksnpower ,
Please have a try.
Mature Warranty % =
VAR CurrentDate =
TODAY ()
VAR WarrantyPeriod =
15 - MAX ( table[change this to your desired warranty period in months ] )
VAR MatureDate =
EDATE ( CurrentDate, - WarrantyPeriod )
VAR Claims =
CALCULATE (
SUM ( Claims[Amount] ),
FILTER ( Claims, Claims[Date] <= MatureDate )
)
VAR Supplies =
CALCULATE (
SUM ( Supplies[Quantity] ),
FILTER ( Supplies, Supplies[Date] <= MatureDate )
)
RETURN
DIVIDE ( Claims, Supplies )
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amksnpower
3 years agoNew Member
Dear Community Team, thank you for the replay & DAX. will try & update you