topic Re: DAX function in DAX Commands and Tips

DAX function

Anonymous — Mon, 04 Sep 2023 09:50:54 GMT

Hi all,I just Append Two tables . I required a DAX Function To show the data Saparetely as Parent Tables when we Apply Slicer.

Can you people please help which DAX expression uses this problem.

e.g : In slicer If I select table 1,It has to show the only table 1 Data,If I select Table 2,It has to show Only Table 2 Data...Like that

Re: DAX function

eliasayyy — Mon, 04 Sep 2023 10:01:16 GMT

before appending create a new column for each table called table

name the first one "Table 1" and the second "Table 2" then append them

and now use the new custom column "Table" as your slicer

Re: DAX function

Anonymous — Mon, 04 Sep 2023 10:27:01 GMT

Yup...But How can we romove Blank rows in Appended table

Re: DAX function

eliasayyy — Mon, 04 Sep 2023 10:33:37 GMT

what do you mean can you hsow me?

Re: DAX function

Anonymous — Mon, 04 Sep 2023 11:11:56 GMT

Ok.. For example we created custom colomns for both the tables.. And append the tables.. Table one data comes first along with custom column.. And table 2 data comes first along with custom colomns... And null values arrived for table 1 data in table 2 custom column... How can we remove those....

Re: DAX function

eliasayyy — Mon, 04 Sep 2023 11:22:24 GMT

can you show me a picture please?

you need to add the same column name so they append under each otehrs

name the custom column "Table" for both tables

once you name the table you need to fill in values,

for table one write "Table 1" for table two write "Table 2"