Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi, can someone please explain me how to check the value returned by a variable in DAX ?
I am using below dax to create a measure for my power bi report and i want to check what value the below variable is
returning ? how do i do it in powerbi ? I dont have DAX Studio.
measure =
var _diff = datediff(minx('Date', startofyear('Date'[Date], "3/31")), today(), Week)
return
divide([measure2],_diff)
Many Thanks
Solved! Go to Solution.
@Anonymous
To check the result of the variable, just add it after the "return" function:
Check variable =
var _diff = datediff(minx('Date', startofyear('Date'[Date], "3/31")), today(), Week)
return
_diff
Proud to be a Super User!
Paul on Linkedin.
what do you want to check it for?
Proud to be a Super User!
@Anonymous
To check the result of the variable, just add it after the "return" function:
Check variable =
var _diff = datediff(minx('Date', startofyear('Date'[Date], "3/31")), today(), Week)
return
_diff
Proud to be a Super User!
Paul on Linkedin.
User | Count |
---|---|
86 | |
82 | |
68 | |
66 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |