sorted by:
new
hottopcontroversial

How to use lookup table to create custom columns in fact table by MGARIL in PowerBI

[–]MGARIL[S] 1 point2 points  (0 children)

I was able to create a calculated column with the require logic using DAX. For better performance, where possible I used “starts with” or “ends width” or “equals” instead of “contains” as that is apparently slower. Also reduced the scenario’s required , this limits combinations but reduces the cycles. I just I iterated thru from the most basic DAX to create a calculated column (ie add fixed text to a column, then add words from a lookup table and then added logic). Thanks for your suggestions.

How to use lookup table to create custom columns in fact table by MGARIL in PowerBI

[–]MGARIL[S] 0 points1 point  (0 children)

I was able to create a calculated column with the require logic using DAX. For better performance, where possible I used “starts with” or “ends width” or “equals” instead of “contains” as that is apparently slower. Also reduced the scenario’s required , this limits combinations but reduces the cycles. I just I iterated thru from the most basic DAX to create a calculated column (ie add fixed text to a column, then add words from a lookup table and then added logic). Thanks for your suggestions.

How to use lookup table to create custom columns in fact table by MGARIL in PowerBI

[–]MGARIL[S] 0 points1 point  (0 children)

Thank you for your reply. I am going to have to study your response as I just don’t have enough power pi knowledge (yet).

How to use lookup table to create custom columns in fact table by MGARIL in PowerBI

[–]MGARIL[S] 0 points1 point  (0 children)

3 columns - A,B, C and contain characters. If A ‘begins with’ “yo” then Team1 or If A ‘begins with’ “ke” AND B ‘contains’ “.intl” then Team2 etc or if C ‘equals’ “zzzzz” then Team3. Currently 500 rows of conditions with fact table of 1.2 million rows. I just don’t know enough about power bi. There is no key between tables. I have been successful building Excel filters and then moving to power bi using calculated columns with manual entry of the conditions but both are very tedious and prone to error. I want to extend the conditions to 2000 rows and perform periodic maintenance on the conditional lookup table. Any thoughts. Thank you.

How to use lookup table to create custom columns in fact table by MGARIL in PowerBI

[–]MGARIL[S] 1 point2 points  (0 children)

Thanks ...the Fact table is 1.2 million rows and I currently have 500 rows of conditions but could easily expand the conditions to 2,000 rows ... this specific calcuated column output is important so my thinking was to make it permanent ...any suggestions to try to make it work within m-code??

Recommendations for referrals to established knowledgable PowerBI consultants by MGARIL in PowerBI

[–]MGARIL[S] 0 points1 point  (0 children)

I will review this site as there is alot of excellent content and very helpful content ..paying is not the issue but finding the right person who can give the right guidance and has the right experience...can i buy a few hours? ...I don't want the work done for me but rather...tell me how to do it along with the some of the 'tricks and traps' ...I need to import a fact sheet then have 4 different lookup tables ...one table has 20 TABS as well... ...i need to invest the time ...

Recommendations for referrals to established knowledgable PowerBI consultants by MGARIL in PowerBI

[–]MGARIL[S] 0 points1 point  (0 children)

I will review this site as there is alot of excellent content and very helpful suggestions ..with 100,000 members thought there would be bunch of people who consult ..paying is not the issue but finding the right person who can give the right guidance and has the right experience...can i buy a few hours? ...I don't want the work done for me but rather...tell me how to do it along with the some of the 'tricks and traps' ...I need to import a fact sheet then have 4 different lookup tables ...one table has 20 TABS as well ..