Forum Discussion

Edske's avatar
Edske
New Member
2 years ago

Measure Newbie

Hello all   Claus from Denmark here 🙂  I am really new to DAX/measurement and are looking for the right function to make a measure on 2 colums. 1 column has "meters" and the 2 column i same row h...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Edske ,
Based on my understanding of your description, you are trying to get a new table containing the two tables you mentioned. If so, you can use the SUMMARIZE function to create a new calculated table. You can refer to this expression to see if it meets your requirements.

New table(Summarized Meters By Date) = 
SUMMARIZE(
    'Table',
    'Table'[Date],
    "Total Meters", SUM('Table'[Meters])
)

For more details about SUMMARIZE function you can refer to this document
SUMMARIZE function (DAX) - DAX | Microsoft Learn

Best regards

Albert He

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly