Forum Discussion

LorenzoC's avatar
LorenzoC
Regular Visitor
2 years ago
Solved

Measure won't work...

Dear All, i have the following dataset: Id Date S_Cost D_Cost Tot_D_Cost 1 01/01/2024 500 1500 3300 1 01/01/2024 500 1800 3300 1 03/01/2024 2000 2500 2500 2 01/02/20...
Need Help
  • Daniel29195's avatar
    Daniel29195
    2 years ago

    LorenzoC 

    output ; 

     

    try the following calculated column : 

    Column =
    var ds =
    CALCULATEtable(
        SUMMARIZE('Table','Table'[S_Cost],'Table'[Date]) ,
        ALLEXCEPT('Table','Table'[Id])
    )

    RETURN
    SUMX(
        ds,
        [S_Cost]
    )



     
    let me know if this helps. 
Daniel29195's avatar
Daniel29195
Icon for Community Champion rankCommunity Champion
2 years ago

LorenzoC 

output ; 

 

try the following calculated column : 

Column =
var ds =
CALCULATEtable(
    SUMMARIZE('Table','Table'[S_Cost],'Table'[Date]) ,
    ALLEXCEPT('Table','Table'[Id])
)

RETURN
SUMX(
    ds,
    [S_Cost]
)



 
let me know if this helps. 
LorenzoC's avatar
LorenzoC
Regular Visitor
2 years ago

Yeah, it does work!
Thanks a lot