Forum Discussion

AaronGlenn10's avatar
AaronGlenn10
Helper III
4 years ago
Solved

Creating an Alias based on associated name

I have a summary of restaurnant location and sales data where there are multiple locations with the same name so I had to concatenate columns to create distinct values for ranking purposes.  However, I would prefer the dashboard to display the restaurant/location name only, instead of the location name + city + zip code + location number) -- is this possible?  Thank you!

 

Location Name/City/Number = TABC[Location Name] & " (" & TABC[City Key] & " - " & TABC[location_zip] & " - " & TABC[location_number]& ")"

 

 

Need Help
  • AaronGlenn10's avatar
    AaronGlenn10
    4 years ago

    PijushRoy 

     

    Location NameTABC Sales (YTD)TABC Sales (TTM)TABC Sales (Current Month)TABC Sales (PY)TABC Sales (Prior Month)TABC Sales MoM %TABC Sales YoY %TABC Sales YoY % (YTD)TABC Sales YoY % (TTM)
    BOTTLED BLONDE- THE BACK YARD (DALLAS - 75204 - 1)$13,016,303$13,016,303$1,182,779$372,854$1,029,19214.92%217.20%194.80%194.80%
    LEVY RESTAURANTS (DALLAS - 75219 - 7)$5,954,354$5,954,354$1,142,662$0$1,695,755-32.62% 56.10%56.10%
    NICK & SAM'S STEAK & FISH HOUSE (DALLAS - 75201 - 1)$8,087,528$8,087,528$873,895$541,321$828,0365.54%61.40%73.80%73.80%
    HAPPIEST HOUR, LLC (DALLAS - 75201 - 1)$9,912,106$9,912,106$780,166$472,946$707,53610.27%65.00%262.50%262.50%
    DFB CAPITAL LLC (DALLAS - 75201 - 2)$9,453,849$9,453,849$739,814$536,407$751,047-1.50%37.90%61.60%61.60%
    HOSPITALITY INTERNATIONAL INC (DALLAS - 75201 - 65)$6,200,159$6,200,159$726,701$367,193$569,84127.53%97.90%100.20%100.20%
    BIERNAT'S RESTAURANT (DALLAS - 75219 - 1)$5,850,108$5,850,108$715,103$400,024$544,62731.30%78.80%84.60%84.60%
    COWBOY'S RED RIVER (DALLAS - 75220 - 1)$5,893,024$5,893,024$655,404$263,585$490,76933.55%148.60%126.00%126.00%
    MKRDY DALLAS BEVCO LLC (DALLAS - 75202 - 1)$3,406,276$3,406,276$599,536$301,577$384,30956.00%98.80%104.10%104.10%
    ROUNDUP SALOON (DALLAS - 75219 - 4)$6,778,924$6,778,924$599,022$302,119$538,61911.21%98.30%269.30%269.30%
    THE HENRY (DALLAS - 75201 - 1)$4,157,863$4,157,863$590,569$362,336$396,36449.00%63.00%67.60%67.60%
    COOL RIVER CAFE CRC01 (DALLAS - 75235 - 1)$3,332,072$3,332,072$581,503$273,041$319,20282.17%113.00%103.30%103.30%
    EPIC ABS LLC (DALLAS - 75201 - 1)$5,385,330$5,385,330$562,596$315,715$378,02948.82%78.20%62.00%62.00%
    OMNI DALLAS CONVENTION CENTER (DALLAS - 75202 - 18)$5,350,773$5,350,773$556,890$120,919$684,945-18.70%360.50%22.50%22.50%
    BABY DOLLS TOPLESS SALOON (DALLAS - 75220 - 1)$5,467,956$5,467,956$539,655$306,499$503,0237.28%76.10%106.60%106.60%
    CITIZEN DALLAS (DALLAS - 75204 - 1)$5,749,373$5,749,373$534,565$0$506,2205.60%  0.00%
    FULLER BIERNAT BEVERAGE LLC (DALLAS - 75254 - 1)$3,759,075$3,759,075$529,031$243,437$328,84260.88%117.30%103.70%103.70%
    VIDORRA (DALLAS - 75226 - 1)$7,052,381$7,052,381$527,870$305,056$498,9925.79%73.00%92.90%92.90%
    THOMPSON DALLAS BEVERAGE, LLC (DALLAS - 75202 - 1)$3,698,712$3,698,712$520,613$170,224$384,65535.35%205.80%1662.80%1662.80%
    SIDECAR SOCIAL (DALLAS - 75254 - 1)$5,339,420$5,339,420$505,700$302,755$452,84011.67%67.00%45.20%45.20%
    VIRGIN HOTELS DALLAS (DALLAS - 75207 - 1)$6,644,115$6,644,115$497,410$405,964$278,64278.51%22.50%41.60%41.60%
    DD BEVCO, LLC (DALLAS - 75202 - 1)$6,468,383$6,468,383$496,797$298,282$522,302-4.88%66.60%133.00%133.00%
    JAVIER'S RESTAURANT (DALLAS - 75205 - 1)$5,225,867$5,225,867$495,558$339,547$451,6719.72%45.90%63.70%63.70%
    OJOS LOCOS SPORTS CANTINA (DALLAS - 75220 - 7)$5,404,677$5,404,677$488,515$291,327$477,0082.41%67.70%54.20%54.20%
    PARADISO/BOTANIST/GOOD COMPANIONS (DALLAS - 75208 - 1)$3,573,294$3,573,294$485,950$333,619$270,08479.93%45.70%49.10%49.10%
    TRUE KITCHEN & KOCKTAILS / FLAIR COCKTAIL LOUNGE (DALLAS - 75201 - 1)$5,864,102$5,864,102$484,101$188,583$498,175-2.83%156.70%552.20%552.20%
  • PijushRoy's avatar
    PijushRoy
    4 years ago

    Hi AaronGlenn10 

    You need to make same solution, I shared below post
    https://community.powerbi.com/t5/Desktop/Filtering-a-Matrix-to-a-specific-row-level-that-contains-a-Value/m-p/2345857#M845913

    Lookup Table:- Go to Power Query and create Refernce table with two col "restaurant/location" & "location name + city + zip code + location number" /or create a table with SUMMARIZE dax function
    Create relationship:- with "location name + city + zip code + location number" between Lookup table and Main Table
    Use "restaurant/location" col from lookup table and data from main table in visulization

    If you have any question, please let me know.
    If solve your requirement, please mark this answer as SOLUTION
    If this comment helps you, please LIKE this comment/Kudos

6 Replies