Forum Discussion

inversia's avatar
inversia
Frequent Visitor
1 year ago
Solved

Last Record Value by Condition

Hi,   thank you for support.   To simplify, I have a fact Table A linked to the DATA Table.   DATA COD TYPE AMOUNT 2024-11-20 A F 0 2024-11-20 A G 15 2024-10-02 A F 10 ...
  • inversia's avatar
    inversia
    1 year ago

    Hi dharmendars007 ,

    thank you so much.

    For each COD the value is correct, but the total is wrong, maybe it get the MAX 

    have you other idea? 

     

    It might be useful create a table like and then make SUM(LastValue) ?

    DATACODTYPEAMOUNTLAST VALUE
    2024-11-20AF0 
    2024-11-20AG15 
    2024-10-02AF1010
    2024-10-03BG5 
    2024-10-01BF11
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
1 year ago

hi inversia ,

 

try like:

measure =

VAR _table =

ADDCOLUMNS(

   VALUES(data[COD]),

    "MinDate", CALCULATE(MIN(data[date])),

)

VAR _result =

CALCULATE(

    SUM(data[Amount]),

    TREATAS(

         _table,

         data[COD],

         data[date]

     ),

    data[TYPE]="F",

    data[amount]>0

)

RETURN _result

  • inversia's avatar
    inversia
    Frequent Visitor
    1 year ago

    Thank you so much