Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Dear all,
I'm looking for a DAX formula.
I have the following data:
From this I want to create a trending graph, so showing 2023ACT and 2024BUD in the same graph, monthly figures.
I would like to have the data of the green items to be displayed in my graph.
So for the 2023ACT the category C2 should be taken. But not when the scenario is 2024BUD. As in 2024BUD I want to have the selection of the scenario's MEN_C2, MEN_C2_ALLOC2 and MEN_C2_CANCEL2.
In the scenario 2024BUD he can't take at all the C2 category, as this is not with monthly figures but only December.
Somebody who can help me with the correct DAX please?
Thanks a lot
Kind regards
Cindy
Hello,
Kindly provide the sample input/output in a good format (excel, csv, table etc.) masking sensitive information.
reference : https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
Thanks,
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
15 | |
11 | |
7 |
User | Count |
---|---|
25 | |
24 | |
12 | |
12 | |
11 |