Solved: Re: How to create an empty table from a list where...

smpa01 · ‎11-29-2022

The title might be confusing.

I have a list as follows

let
    Source = {"c1","c2","c3"}
in
    Source

I want to end up with an empty table as this is where the column names come from the list values.

@ImkeF @AlexisOlson @watkinnc

Thank you in advance

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

My custom visualization projects

Plotting Live Sound: Viz1

Beautiful News:Viz1, Viz2, Viz3

Visual Capitalist: Working Hrs

Others:Easing Graph, Animated Calendar

CNENFRNL · ‎11-29-2022

let
    Source = {"c1","c2","c3"},
    EmptyTable = #table(Source,{})
in
    EmptyTable

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

View solution in original post

CNENFRNL · ‎11-29-2022

let
    Source = {"c1","c2","c3"},
    EmptyTable = #table(Source,{})
in
    EmptyTable

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

watkinnc · ‎11-29-2022

Flattered to be included with such illustrious company.

--Nate

I’m usually answering from my phone, which means the results are visualized only in my mind. You’ll need to use my answer to know that it works—but it will work!!