Measure Newbie

[Edske]

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 has a date. I am looking for the right measure for doing a summarized dates based on meters. 

Best Claus 🙂

[Anonymous]

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

[Edske]

The "Idriftsat måned" is date field and the "Tracé længde" are in meters.

Output should be a new Table with "Date" and summarized "Meters"

I hope this was what you meant by "Sample data"

Best

Claus 😀

[johnyip]

You need to provide some sample data and your desired output. We cannot provide the DAX if there are no sample data.

[Daniel29195]

@Edske 

can you please provide the output of what you are looking for ? that would be helpful in order to help in with yourr question 

f my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution !✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

[Edske]

Hello Daniel

My output should be a colum with dates and summarized meters. 

[Daniel29195]

@Edske 

you just need to add the data to a visual,

and it will automatically summarize your data .

hope this helps .