Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
We run a strange month, it's the last Monday of the previous month to the last Sunday of the current month (so October would be 25th Sept 2022 to 31 October 2022).
This means that slicing doesn't work nicely for months in my scenario using the date column in my main table. I'm trying to build two visuals: one that shows data for current month and one that shows it by month for the year (remember these are my strange months). I have data in my main table (Time Sheets) that I'm summing/etc:
and a date table (you can see my strange months):
I can't seem to:
Have I sent myself down a rabbit hole/is there another way to solve this?
@thinkinfox , Try a measure like below, it is based on today
Measure = //Current month is nov
var _date = eomonth(today(),-1)
var _mind = eomonth(today(),-2)
var _min = _mind -weekday(_mind,2)+1
return
calculate(Sum(Table[Value]), filter(Table, Table[Date] >=_min && Table[Date] <=_max))
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |