Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
Below is the table which I am using in my report and I am facing challenges while trying to calculate the SUM of MAX 't_mauc_1' value by latest 't_trdt' column ( The datetime may remain same or different even if the values in the 't_mauc_1' column are different ). So in this case my output should be as in the second screenshot. Is there a way to handle this in DAX, I am new to DAX and need help on this one ?
Thanks
I tried the measure but received the below error.
@ambresameer , Try a meausre like
sumx(values(table[t_item]), calculate(lastnonblankvalue(Table[t_trdt], max(Table[t_cpcp]))))
I tried the measure but received the error instead after using that in the visual. You can see that in the above screenshot.
User | Count |
---|---|
47 | |
26 | |
22 | |
17 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |