Forum Discussion
Comapring Number Values from same column with text values from same column
See above
Hi etwa702 ,
PercentDif is the table name. Sometimes the errors appear due to missing syntax. Anyway here is the file. It is a recovered file, and not sure where the hierachies came from, but didn't use them. Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
WOW, this looks great!
Just saw this on my dataset and I love it.
i did notice that based on my data there are some Test Runs that did not have a result for the Transaction name, must be because that test did not test that page.
Example, OCT build tested 10 pages only and SEP build tested all 13 pages, SEP build would have a value and based on that then states that it is the winning build and it should instead not show any calculation.
Possible to help me with filtering out the blank values?
Thank you for this, great help!!!
Hi etwa702 ,
OK, created a new measure "...Revised" That wrapped "Winning Build with an if statement. So just compare the two and make the change. You could if you wish define the granularity even more, and add another if to determine whether it is "Sept Test not performed."
Glad I could help!
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
NathanielWinning Build Revised = IF( ISBLANK([Sep Final]) || ISBLANK([Oct Final]),"Test not Performed", IF([Oct Final]>[Sep Final], "Oct Final" , If([Sep Final]>[Oct Final],"Sept Final","SAME Result")))
Tested on page 2
Here is my actual PBI file, so we could perhaps work together.
I added the measures in (noticed the % diffirence measure breaks, still figuring out why).
Added the new Winning Build, (which now workes with blanks, THANKS).
I have test results passing into new months, do I need to build the DAX for each of them or is there some way I can do the calculations dynamically so they span accross new data that comes into the file?
See above