Forum Discussion
Fantmas
Helper III
2 years agoTreat as function not working with variable
Hi Everyone, I have the following DAX expression my issue is when I use this expression with le variable _Year is returns me a blank when I harcode the period I want example "2021.TOTAL", it is wo...
amustafa
Solution Sage
2 years agoYou can do some debugging by creating individual measures for each part of your expression (like for default_year, selected_year, and _Year) and use them in a table visualization to see their individual outputs. This can help you pinpoint where the problem lies.