Forum Discussion
Need help - Report Filtering
Hi,
Thank you for your response. Find below a picture of the columns I am working with.
Each Company has a number of tasks that represent stages in our procedures. The columns reperesent TaskID, Description and also a field containing a date if that stage has been completed.
I would like to generate a table of companies that is filtered by only those that have a date within the Task ID "30" i.e. Recieve final accounts and that has no date within the Task ID "11" i.e. Send to client for signature.
Hope that helps.
Hi Anonymous ,
I think your environment like below:
We can use the following measure to filter it:
Measure =
IF (
MIN ( Table1[TaskId] ) = 30,
IF (
CALCULATE (
MIN ( Table1[End] ),
FILTER (
ALL ( Table1 ),
Table1[ClientCode] = MIN ( Table1[ClientCode] )
&& Table1[TaskId] = 11
)
)
= BLANK (),
1
)
)Best Regards,
Teige
Hi,
Thank you very much for the recommended forumula. I appreciate the time you must have spent in preparing this.
How do I got about entering this forumla as a filter within PowerBI? I have been unable to find the ability to filter by formulas. In addition to this, is it possible to enter conditional formatting formulas that I have used within excel within PowerBI?
Thanks again.
Hi Anonymous ,
Could you please share the expected image to me? I think I can't understand your "enter conditional formatting" and "filter" in this scenario.
Best Regards,
Teige
Hi
Regarding the filtering:
How do I apply the formula you have prepared within PowerBI to my table? I can only find the simply filter options available to the right of the reporting area.
Regarding the conditional formating:
Is it possible to apply more complex formulas to my tables within PowerBI. I can only find the default options as shown below.