Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I want to show a bar chart comparing month by month 2 different measures:
a) Total actual expenses (from the origin to the last month extracted -but excluding the current month-)
b) Total expenses budgeted (from the origin to the end of the project; in this case we don't have to exclude any date)
My question would be what measure can I use for the Total Actual Expenses (a), excluding the current month inside the formula?
I think it has to be inside the formula. The problem is that I can't use a slicer as a filter for dates for the specific visual object, as I do want to show all dates for the comparative measure "Total expenses budgeted (b).
So I think that the only solution would be to create a measure with CALCULATE filtering dates in somewhow... E.g.:
CALCULATE ([Total actual expenses];ALLEXCEPT('DATES';¿(current month)?))
Another idea? I would be very grateful if someone could solve this question.
Thanks
Regards
Solved! Go to Solution.
you could create a custom column like this:
IsCurrentMonth =
IF (
YEAR ( Table[Date] ) = YEAR ( TODAY () )
&& MONTH ( Table[Date] ) = MONTH ( TODAY () ),
"Yes",
"No"
)
and then filter the visual on this column -> IsCurrentMonth = "No"
you could create a custom column like this:
IsCurrentMonth =
IF (
YEAR ( Table[Date] ) = YEAR ( TODAY () )
&& MONTH ( Table[Date] ) = MONTH ( TODAY () ),
"Yes",
"No"
)
and then filter the visual on this column -> IsCurrentMonth = "No"
Thank you very much. It works perfectly!
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |