Forum Discussion

lisago1978's avatar
lisago1978
Helper III
7 years ago

Help with conditional columns referencing total amounts

I need some insight into how to create the following in either power query or power BI   I have a series of zipcodes that I am referencing the individual zip code % yes confidence interval (margin ...
Need Help
lisago1978's avatar
lisago1978
Helper III
7 years ago

Thank you for the response. The code didn't exactly work. It said I was missing a comma but couldn't put it in. The other problem is that the Totals table will need to have more than 1 row since  I have multiple indicators and multiple totals in the same table. So I would need code that matches a specific text indicator for example "low birth weight" and a datayear "2010" and then finds the LCI and UCI in that row to compare to the data table with matching text and year indicator rows. I am happy to send the 2 tables I am refering to if this helps.

 

Thanks

Lisa

HotChilli's avatar
HotChilli
Community Champion
7 years ago

I knew your real data was different! 

Send the tables and i'll have a look.

 

 

For the initial "missing comma" issue, there's either a syntax error at your side OR the column headings and types are wrong in the 2 tables.  The code works when the tables are set up correctly.

  • lisago1978's avatar
    lisago1978
    Helper III
    7 years ago

    Thanks, I don't think I can send an attachment with my tables using this community forum, it you know of a way let me know. I can't share my dashboard with you because I am limited only to those in my organization in terms of how our permissions are set up. If you have an email address I can email the tables to you.