Forum Discussion
Help Please.. Custom Colum Filter Value Doesn't Match Measure Value
Heya,
Do you think you can provide a sample of your data (after you stripped it form any confidential information?
Either way, I would stay away from Blank values, especially when it comes to numerical data. Either in Power Query or in the table data itself replace the Blanks with 0 and see if the formulas are corrected.
Cheers,
PS: if this solved your problem then please mark it as the solution so others can see it.
Hi MNedix appreciate the input, I'll give it a try, though not quite sure how to replace the blank values to 0 as a sale can either be a credit or invoice and always has values, just that they show as blank on dates that a customer doesn't have a purchase..
unfortunately I am unable to send in the data as it has lots of conf info 😞
my first time doing such filters/dynamic conditions so not quite sure where I'm headed really haha, but I will try not to use blanks and see where I go from there thanks again