Forum Discussion

DocDri's avatar
DocDri
Helper I
9 months ago
Solved

Power-BI removes column automatically when saving

Hello,   i create a new table using DAX with this query:   QG Times Table = var ppsel = SELECTCOLUMNS( FILTER('PP','PP'[EKey]="GG"), "GKey",'PP'[GKey], "ValueX",CALCULATE(MAX('XTable'[ValueX...
Need Help
  • DocDri's avatar
    DocDri
    9 months ago

    Hi all & thanks for your replies! I tried it again, with exactly the same code & it then worked. Seemed to be a temporary problem / bug, which now does not pop up again. 

Nabha-Ahmed's avatar
Nabha-Ahmed
Super User
9 months ago

Hi   DocDri 

It appears the calculated table you created with the DAX:

 

 
QG Times Table = VAR ppsel = SELECTCOLUMNS( FILTER('PP','PP'[EKey]="GG"), "GKey",'PP'[GKey], "ValueX",CALCULATE(MAX('XTable'[ValueX]),'XTable'[ExtKey]=EARLIER('PP'[GKey]) && 'PP'[Milestone]="M1") ) RETURN ppsel

works initially, but when you save the file the "ValueX" column disappears.

What to check:

  • Ensure that 'XTable'[ValueX] and 'XTable'[ExtKey] have the correct names and data types, and those columns exist at model refresh time. If the referenced column doesn’t exist (or is renamed), Power BI may drop the created column. Microsoft Fabric Community+1

  • Confirm you are not in a mode (e.g., DirectQuery) or have any limitation that prevents materializing calculated tables/columns. Some features aren’t supported in certain storage modes.

  • After editing the DAX, save the file and perform a refresh so the calculated table gets fully processed and stored. If the refresh fails silently or fails to include the column, then the column will appear missing.

  • Consider whether you need to evaluate the logic differently (e.g., EARLIER sometimes needs very careful context). If the filter context results in no rows, the column might exist but be blank or invisible

  •  

  •  

  •  

DocDri