Forum Discussion
Tricky Concatenate DAX Formula
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 ...
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