Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I have some document number transaction that sometimes can bring the same value but in multiple dates, so I need to bring just the value for the last date the most recent, but I need to sum the most recent value for each document number, could someone help me?
Hi,
Create a Date column by using the following calculated column formula
Date= 1*("1/"&Data[Month]&"/"&Data[Year])
Create a Calendar Table with a relationship (Many to One and Single) from the Date column created above to the Date column of the Calendar Table. To the Table visual, drag Document number column. Write these measures
Amt = sum(Data[Amount])
Measure = CALCULATE([Amt],LASTNONBLANK('Calendar'[Date],CALCULATE([amt])))
Share some data to work with (in a format the can be pasted in an MS Excel file) and show the expected result.
User | Count |
---|---|
98 | |
89 | |
82 | |
70 | |
67 |
User | Count |
---|---|
114 | |
104 | |
101 | |
72 | |
65 |