-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
blanket
-
M
DAX calculated column hanging - optimize or build in Power Query?
I have a calculated column to categorize spend types in a 8+ million row table. The existing version posted below works, but I need to add one more variable (potentially doubling the number of categories) and when I try it works in the data model window but Excel goes bye-bye when I go into...- macfuller
- Thread
- blanket catalog scripted var
- Replies: 0
- Forum: Power Tools
-
B
Nested If formula
Hi, My head is a bit pickled, I am trying to run an If formula but not getting it right. Can you help? I need to be able to get the below two formulas to work together for both Beanie and Blanket: =IF(S2="123",IF(ISNUMBER(SEARCH({"beanie","hat"},R2)),"Beanie"),IF(S2="456","Ignore"))...- Balmer07
- Thread
- beanie blanket formula formulas work
- Replies: 2
- Forum: Excel Questions
-
M
DAX Measure Optimization for Multiple Tables
I have a brutally slow measure, and I need to create several more like it with contrasting logic in order to break down our spend in the categories a consultant is telling us to. Before I slow my model to a crawl I was hoping someone could help with optimization? Controlled PO no Pharmacy :=...- macfuller
- Thread
- blanket measure orders[type] vouchers
- Replies: 2
- Forum: Power Tools
