Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don'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.

Reply
CVL
Regular Visitor

DAX formula to be used in trending graph

Dear all,

I'm looking for a DAX formula.

I have the following data:

CVL_0-1712587434425.png

 

 

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

1 REPLY 1
adudani
Super User
Super User

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,

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a Kudos 🙂
Kind Regards,
Avinash

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.