The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi community!
I have a table that shows me several records per day for each article:
Article | DateTime | Value |
A | 01.01.2022 01:00:00 | 5 |
B | 01.01.2022 01:50:00 | 8 |
C | 01.01.2022 08:00:00 | 6 |
B | 01.01.2022 01:00:00 | 2 |
Each article has for each dax the same amount of rows with the same datetime.
Now I would like to sum the value for each article always for the first DateTime per Day.
How would you do that using DAX?
Hi @joshua1990 ,
Having trouble to follow.
What is the expected result?
A table like below:
Article | DateTime | Value |
A | 01.01.2022 01:00:00 | 5 |
C | 01.01.2022 08:00:00 | 6 |
B | 01.01.2022 01:00:00 | 2 |
Or a single value which is 5+6+2 = 13?
Best Regards,
Jay
Hi:
I will attach a solution. You will see I added just a Data column to your table and the visual on page one is set to not summarize.
https://drive.google.com/file/d/1ydN4Y-C4RIwgvft_KBQgI84UzIXLWaOE/view?usp=sharing
User | Count |
---|---|
10 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
20 | |
15 | |
14 | |
10 | |
7 |