Forum Discussion

osama_ayoub's avatar
osama_ayoub
Helper III
3 years ago
Solved

creating measure using dax

Hi, I have a table of sales transaction with columns of product and quantity and date of sale and years of warrenty and column of date when this quantity will be out of warrenty and lastly status co...
@Dax help
  • tamerj1's avatar
    tamerj1
    3 years ago

    osama_ayoub

    Since you already have a date table then no need for a Years table. Sorry for that but I did not have all the information about your data model.

    Two relationshops have to be created. One "Active" between DateTable[Date] and Query[Basic fin.] and other "Inactive" between DateTable[Date] and Query[Out of Warranty]

    The measure would be 

     

    Remaining Quanitiies of Product Still in Warrenty =
CALCULATE (
    SUM ( 'Query'[Del. qty] ),
    'DateTable'[Year] >= MAX ( 'DateTable'[Year] ),
    USERELATIONSHIP ( 'Query'[Out of Warranty], 'DateTable'[Date] )
)

     

tamerj1's avatar
tamerj1
Community Champion
2 years ago

osama_ayoub 

It should be <= not >=
that was a mistake from my side. 

osama_ayoub's avatar
osama_ayoub
Helper III
2 years ago

tamerj1

I reversed the sign but now It corrected the firs part but the second part (the curve should be go down with every unit outing from warrenty )
Regards

 

  • tamerj1's avatar
    tamerj1
    Community Champion
    2 years ago

    osama_ayoub 

    It cannot as this is a running total. Unless you remove completely the filter argument but only keeps the USERELATIONSHIP then you would obtain the trend that you've described. But that won't be a running total.