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
Hi all,
I have the following table in Power BI desktop created. All columns are measures.
I received feedback today that the following employee (name field) started on the 01-2018 at his business unit, and thus should not have written any hours in the month of july. Therefore I want to add a filter or something to make sure that if the contract starting date value (which is written in a column, in a table) is month x, that no registrated hours/contract hours are shown from the months before. But only the months ongoing from the starting date. However, I have NO clue how to achieve this...
Anyone an Idea? Sorry for the very vague description...
Many thanks in advance!
| year-month | july-18 | |||
| Name | FTE | Contract hours | Written hours | delta |
| John Doe | 1 | 176 | 56,5 |
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.