Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
Solved! Go to 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
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 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)
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
User | Count |
---|---|
51 | |
38 | |
20 | |
14 | |
13 |
User | Count |
---|---|
98 | |
71 | |
29 | |
18 | |
13 |