Forum Discussion
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 has a date. I am looking for the right measure for doing a summarized dates based on meters.
Best Claus 🙂
6 Replies
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! 🤠Hello Daniel
My output should be a colum with dates and summarized meters.
you just need to add the data to a visual,
and it will automatically summarize your data .
hope this helps .
You need to provide some sample data and your desired output. We cannot provide the DAX if there are no sample data.
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 LearnBest regards
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
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 😀
