Trouble Writing MDX Queries

[PeterPowerBI]

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 using SAP BW Application Server as the data source.

Desired Result:
Example:
(where basic finish date [20FINISHDATE] = 01.09.2022)

Source I need to populate:

 

[v-mengzhu-msft · Accepted solution]

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

[Greg_Deckler]

@PeterPowerBI So, if you use the Navigator and such you may not have to hand-write MDX. If you need to hand-write MDX you'll have to learn MDX:

Writing MDX Queries (oracle.com)

[PeterPowerBI]

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