Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Experts
I have the following dax formula which works fine to a certain limited. i want to change it so if the YTD,MTD and QTD is selected from the date calculation filter and when NO month is selected then the title should read "total revenue summary".
i cannot see my error...
Title - 1A Product Details = CONCATENATEX( VALUES( 'Date Calculations'[Date Calculation]), 'Date Calculations'[Date Calculation],", ") & " " & IF(HASONEVALUE(DateFilter[Month Short Name]),"",CONCATENATEX ( VALUES( DateFilter[Month Short Name]), DateFilter[Month Short Name], ", ") &" " & CONCATENATEX( VALUES( DateFilter[Year Nbr]), DateFilter[Year Nbr], ",") & " Total revenue summary")
Solved! Go to Solution.
Hi @Anonymous,
The formula seems fine but the result may not be the desired one. Can you share a sample, please? Please mask sensitive parts first.
Do you really have a column of "YTD, MTD and QTD"?
Best Regards,
Dale
Hi @Anonymous,
The formula seems fine but the result may not be the desired one. Can you share a sample, please? Please mask sensitive parts first.
Do you really have a column of "YTD, MTD and QTD"?
Best Regards,
Dale
It is difficult to give you an answer. You would be well advised to use the Variables Syntax and work your way through the problem one step at a time. Have a look at the video I did with Avi here. Watch the video to see how I use VAR to solve complex nested DAX formulas, then apply the process to your formula.
Thanks Matt....
i give it a try
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |