Forum Discussion

TimK's avatar
TimK
Helper III
4 years ago
Solved

Extracting Dates from Totals

I am having problems extracting dates from a Measure   I attach my Pbix file HERE The [Values] are multiplied by their corresponding inflation factor using a Measure called [Inflated Figure]   ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago
    Repalce Ste 3 Dax ... Change Max to min


    Var MDate =
    Var _DD = 'Summary Table'[DD]
    Var _LM = 'Summary Table'[L/M]
    Var _P = 'Summary Table'[P]
    Var _price = 'Summary Table'[Maxvalue]
    Var Output =
    CALCULATE(
    min('Summary Table'[Date]),
    FILTER(ALL('Summary Table'),
    'Summary Table'[DD]=_DD&&
    'Summary Table'[L/M]=_LM&&
    'Summary Table'[P]=_P&&
    'Summary Table'[Total]=_price
     
     
    )
    )

    Return
    Output
Anonymous's avatar
Anonymous
Not applicable
4 years ago
Repalce Ste 3 Dax ... Change Max to min


Var MDate =
Var _DD = 'Summary Table'[DD]
Var _LM = 'Summary Table'[L/M]
Var _P = 'Summary Table'[P]
Var _price = 'Summary Table'[Maxvalue]
Var Output =
CALCULATE(
min('Summary Table'[Date]),
FILTER(ALL('Summary Table'),
'Summary Table'[DD]=_DD&&
'Summary Table'[L/M]=_LM&&
'Summary Table'[P]=_P&&
'Summary Table'[Total]=_price
 
 
)
)

Return
Output
  • TimK's avatar
    TimK
    Helper III
    4 years ago

    ankitgogri - thank you very much for your very speedy help - really appreciate that