Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Im trying to get the measure sum of a column from a table by the dates of the second column and display as sum which is then filtered by the date calander.
Example:
|
The return should be $325, Which then should be able to be filtered down further by a slicer date table.
thanks
Solved! Go to Solution.
hi @Napes001 ,
try to plot the month column with a measure like:
measure =
CALCULATE(
SUM(data[Ordered Amount]),
data[Delivery Date]<>BLANK()
)
it worked like:
I figured out the issue, I had an inactive date relationship. Added in the USERELATIONSHIP and it now works correctly. thank you for your help.
The table columns are similar to the above table with blank dates. The expected result would be: SUM of "Ordered Amount" with dates.
So based on the table on the original post, My expectation is that the result would be $325 - only sum of Ordered Amoiunt that has delivery dates.
This would then be able to be filtered with the Date calander. IE: Filter by Jan 2023 = $250, Feb = $75 = March = $0.00, etc
I hope this makes sense?
hi @Napes001 ,
try to plot the month column with a measure like:
measure =
CALCULATE(
SUM(data[Ordered Amount]),
data[Delivery Date]<>BLANK()
)
it worked like:
Thanks @FreemanZ, This appears to be working to an extent. But when I try and filter with my Calander table it wont show anything past 'todays' data?
If I dont filter, it shows the total correctly of past, present and future. I have added a image to hopefully clarify. I appreacitate your help, This is all a new learning
.
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
86 | |
84 | |
52 | |
37 | |
23 |