Forum Discussion

pfprado's avatar
pfprado
Frequent Visitor
10 years ago
Solved

How to get minimum value from range date in DAX

I need to get a calculated measure of the minimum date of a range of values, ie I have a fact table with a date and two measures. When I filter by range date, I need to get the second measure of the...
  • BhaveshPatel's avatar
    BhaveshPatel
    10 years ago

    AND AT LAST CREATE A FINAL MEASURE

     

    FINALMeasure = CALCULATE([mymeasure],ALL('fact'[Group]))

     

    This will defintely solve your problem.

  • pfprado's avatar
    pfprado
    10 years ago

    Thanks a lot! you really help me

BhaveshPatel's avatar
BhaveshPatel
Super User
10 years ago

FIRST CREATE A MEASURE

 

Sumofmeasure2 = SUM('fact'[Measure 2])

 

AND ON TOP OF THAT CREATE ANOTHER MEASURE

 

mymeasure = CALCULATE([Sumofmeasure2],FILTER('fact','fact'[Date]=MIN('fact'[Date])))

 

IT WOULD SOLVE YOUR PROBLEM IF I TOOK YOUR REQUIREMENTS CORRECTLY.

 

LET ME KNOW HOW IT GOES.

BhaveshPatel's avatar
BhaveshPatel
Super User
10 years ago

AND AT LAST CREATE A FINAL MEASURE

 

FINALMeasure = CALCULATE([mymeasure],ALL('fact'[Group]))

 

This will defintely solve your problem.

  • pfprado's avatar
    pfprado
    Frequent Visitor
    10 years ago

    Thanks a lot! you really help me