Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I am stuck with the following problem.
I am trying to align daily app login stats according to the week of the login.
Example :
Monday 3 Feb | Week 1 of February | 7 Login
would need to be compared to
Monday 2 March | Week 1 of March | 5 Logins
And then all subsequent days would match according to the day of the week ie Tuesday 4 Feb vs Tuesday 3 March.
I am able to create a measure and/or column to identify the week no, the week no of the month, the 1st working day of the month, 1st Sunday or Monday of the month etc, but cannot incorporate this into a visual that matched accordingly.
Any guidance would be appreciated.
Create a working day in calendar
Work Day
Then have new column like
Work day No = countx(filter(date,Date[Month year] = earlier(Date[Month year]) && Date[Date] <= earlier(Date[Date])),date[Work day])
Thanks, appreciate the quick response.
In your example :
What does [Work day] column hold ?
Month year is just a column : FORMAT('Date'[Date],"mmm yyyy") ?
I use the following measure to get the 1st Monday of the each month
I can't upload file unfortunately as our network access does not allow for it
@eishman ,
Could you please paste some sample data and clarify more details about the expected result?
Regards,
Jimmy Tao
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |