Forum Discussion

PeterPowerBI's avatar
PeterPowerBI
Frequent Visitor
3 years ago
Solved

Trouble Writing MDX Queries

Hi All, I'm having trouble understanding how to write a mdx query and I'm not sure how to write it to construct the below excel example. Could I please some help in achieving the below result? I'm...
BW
mdx
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi PeterPowerBI ,

     

    What's MDX? I learned that it seems to be a statement in SSAS, not in power bi.

     

    For your question, what I can do is to give you some reference to the statement document ~ hope it will help you.

     

    The Basic MDX Query (MDX) | Microsoft Learn

     

    Best regards,

    Community Support Team Selina zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

PeterPowerBI's avatar
PeterPowerBI
Frequent Visitor
3 years ago

Hi Greg,

Is it possible just to provide me an example of how you would write the above?

I would add more columns and logic, but just wanted to see a sample and work from there. I get a bit overwhelmed with a lot of reading.

Thanks,
Peter