Forum Discussion
Solved
Advanced Filtering and Custom Formulae
Hi, I have some project data in Excel that I report on using PowerBI. Here's a snippet of the data and some information on what I wish to do:- Requirement: Duration Days excluding 'Pushout'. Fo...
I worked in the end. Rubbish PowerBI - the visual I had didn't work, so I created a new one and it worked. Please fix this in the next release of PowerBi as it was driving me insane! Thanks for your help.
Yes _ i know you strip out #=2, however it's not working for me still. Let me have another try again, but thanks for your help.
I'm just wondering what checking routine, via formulae, I can plug in to test? Can you help me with this?
Thank you.
Quick question: It's not doing this: right ( Sheet1[Task Name], 4 ) = "Test") (I replaced 'Pushout' to 'Test') and it's not working. Help please? Thanks.