Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

How to create a table in Dax

Hello everyone, 
In advance, sorry for broken english. 
So, I need help creating a table inside dax where i can unite two measures with a data collumn. Something like this: 

Can anyone help me with that? 

Thanks! 

Need Help
Tips and Tricks
Tutorial Requests

3 Replies

  • Arul's avatar
    Arul
    Icon for Super User rankSuper User
    4 years ago

    Anonymous ,

    Can you let me know your current and expected output by providing appropriate screenshots of both?

    Thanks,

    Arul

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, Anonymous ;

    Try it.

    new table =
SUMMARIZE (
    'table',
    [date],
    "Gn_executed/GF", SUM ( [Gn_executed/GF] ),
    "PhysicalGuarantee_Sazon", SUM ( [PhysicalGuarantee_Sazon] ),
    "GF_Sazon_YTD", ["GF_Sazon_YTD],
    "Generation Real/Forecast", [Generation Real/Forecast]
)


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I thank you all for trying to help me, but none of your suggestions worked. And now I found out a new problem with my dax formula. I will create another post explaning my new issue.