Forum Discussion
Calculate table, using filters on different tables
Hello all!
I am fairly new to Power BI and completly new on this forum 🙂 Hopefully some of you can point me in the right direction, after a few weeks of Googling..
I am working on a report showing different types of hours in Project Operations. The overall design is:
The hours are stored in msdyn_timeentry. I have made to calculated tables: "Running hours" and "Project hours". The difference between the two is the value of "crb27_faktureringsname" (Running hours and projects). It is also possible to define billable Yes/No on the projecttask (msdyn_projecttask, crb27_faktureringsname.
I am trying to find the hours that are not in the two other tables. The code below is working, but some hours falls through the cracks.
I would like the filter to ble: filter1 OR filter2. Not filter1 AND filter2 like the code below. But I cant figure out how to write an "OR"-filter on two seperate tables. Hopefully somebody can give me a hint!
Unbillable hours =
CALCULATETABLE (
'msdyn_timeentry',
FILTER ('msdyn_project', msdyn_project[crb27_faktureringname]="Not payable"),
FILTER ( 'msdyn_projecttask', msdyn_projecttask[crb27_faktureresname]<>"Yes")
)
Hi jelaag ,
It seems the two tables have same columns according to your formula?
You may try:
UNION( FILTER('msdyn_project', msdyn_project[crb27_faktureringname]="Not payable"), FILTER ('msdyn_projecttask', msdyn_projecttask[crb27_faktureresname]<>"Yes") )If I misunderstood your meaning, please show some sample data and expected result to us.
Best Regards,
Jay
1 Reply
Hi jelaag ,
It seems the two tables have same columns according to your formula?
You may try:
UNION( FILTER('msdyn_project', msdyn_project[crb27_faktureringname]="Not payable"), FILTER ('msdyn_projecttask', msdyn_projecttask[crb27_faktureresname]<>"Yes") )If I misunderstood your meaning, please show some sample data and expected result to us.
Best Regards,
Jay