Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I have a table which contains the hour logs. I have the fields "logged hours" which is a decimal and "logged on" which is a date field. In my report I need to filter the logs for the current month.
Solved! Go to Solution.
Create a calculated column like:
IsCurrentMonth = IF(MONTH([Date]) = MONTH(TODAY()),1,0)
Create a calculated column like:
IsCurrentMonth = IF(MONTH([Date]) = MONTH(TODAY()),1,0)
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 97 | |
| 76 | |
| 52 | |
| 51 | |
| 46 |