Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Good afternoon, I'm new to Power Bi.
I want to calculate the total of Tuesdays and Thursdays contained in a month.
Example: July/2021 tendria 9.
I've tried but haven't figured out how to make it work.
Solved! Go to Solution.
@Syndicate_Admin
Create a measure as follows, add a the month column from our dates table and the measure
Day Count =
var __lastdate = MAX(Dates[Date])
var __firstdate = EOMONTH(__lastdate,-1)+1
return
COUNTROWS(
FILTER(
CALENDAR(__firstdate,__lastdate),
WEEKDAY([Date],1) IN {3,5}
)
)
:
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Syndicate_Admin
Create a measure as follows, add a month column from our date table, and measure
Day Count =
var __lastdate = MAX(Dates[Date])
var __firstdate = EOMONTH(__lastdate,-1)+1
return
COUNTROWS(
FILTER(
CALENDAR(__firstdate,__lastdate),
WEEKDAY([Date],1) IN {3,5}
)
)
:
@Syndicate_Admin assuming you have a calendar table in your model, if not, you can add one following my blog post Create a basic Date table in your data model for Time Intelligence calculations | PeryTUS IT Solutio...
and now you can add the following measure to count the number of Tuesday/Thursday in a month
Tuesday and Thursday Count =
CALCULATE ( COUNTROWS ( 'Calendar' ), WEEKDAY ( 'Calendar'[Date], 2 ) IN {2,4} )
To visualize, use table visual, add Month from calendar table and above measure and you will get the count.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Syndicate_Admin
Create a measure as follows, add a the month column from our dates table and the measure
Day Count =
var __lastdate = MAX(Dates[Date])
var __firstdate = EOMONTH(__lastdate,-1)+1
return
COUNTROWS(
FILTER(
CALENDAR(__firstdate,__lastdate),
WEEKDAY([Date],1) IN {3,5}
)
)
:
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thanks a lot!! I worked properly.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |