Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Breaking Data into Categories using a text string in the field

So im fairly new to PowerBI and have a spreadsheet I am trying to replicate the function of.    Its a finance sheet that does expense tracking. I load all of my monthly or yearly transactions into ...
Need Help
v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous 

 

Can you help explain what does IF(SUMPRODUCT(--ISNUMBER(SEARCH(Lists!B$2:$B$3,$B22))),$D22,"") do? Where is this formula used and what result does it get? Currently I don't understand what sample data is used in cells like B2, D22, B22, B3. Can you explain the expected output with some sample data? Paste sample data in table format in the post so that we can use it to create a sample file. 

 

Best Regards,
Community Support Team _ Jing