A table not visible in edit queries

[Ranahazim]

why one of the tables doesnt apear when i open edit querie?

i try to merge 2 tables, one of them is a date table and its not visible when i hit edit query..   

Also it has a lighter table color that i dont understand 

here to the left i cant find the date table

[MFelix · Accepted solution]

Hi @Ranahazim,

Is this DimDate table made with DAX?

Table made with DAX are not available in the query editor since this uses M Language for the coding, although some steps when made in the Report Editor appear on the query editor (example: renaming columns or deleting columns in tables) creating a new table in the report view will not have any reflection on the query editor.

You can do a DimDate table also on M Language, check this link with the coding and example.

Regards,

MFelix