Forum Discussion

TimK's avatar
TimK
Icon for Helper III rankHelper 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

 

With a combination of AA]&[L]&[One] you have two ID 1 and 45 

use the following Code in your Summary Table


Thanks

  • TimK's avatar
    TimK
    Icon for Helper III rankHelper III
    4 years ago

    hi ankitgogri

    Thanks for this........sorry i dont think i explained it correctly.....

    So with the data in the model, i do not want to look at the maximum values at ID level; i want them at the aggregated [DD], [P], [L/M] level - so the total for this row is 56,661.99 and the maximum value in the row is 10,187.91 on 01/07/23

     

    Does that make sense?