Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
is there any method to calculate the total volume for the whole month based on the last date in a table
e.g
if the data for april went up to 27th April. i would like to calculate the volume for all dates in april.
Solved! Go to Solution.
Hi @NewbieJono
You can use something like :
the pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi @NewbieJono
You can use something like :
the pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hello @NewbieJono ,
Please try the following DAX measure:
TotalVolumeForMonth =
VAR _LastDateInMonth = MAX('Table'[Date]) // Assuming 'Date' is your date column and it is properly formatted as a date.
VAR _StartOfMonth = STARTOFMONTH('Table'[Date])
VAR _Result =
CALCULATE(
SUM('Table'[Volume]),
'Table'[Date] >= _StartOfMonth && 'Table'[Date] <= _LastDateInMonth
)
RETURN
_Result
If it satisfies your needs, please do not forget to mark my reply as the solution. Cheers!
User | Count |
---|---|
93 | |
85 | |
77 | |
68 | |
62 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |