Forum Discussion
Helper VParameter for measure Calculation
Hi All,
I was trying to create a Parameter and blank querry where i can use it for the measure calculation.
For some reason my blank quarrey is not working. can some one help me where i am going wrong?
Hi RanjanThammaiah ,
If I understand you correctly, you can try these two workarounds:
1. Change the code like this:
let Query1 = #table({"ParameterCloseDate"},{{#"LatestWeek"}}) in Query12. Or, you can just keep "LatestWeek" parameter "Enable load". Then you can use it in Power BI Desktop.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- Icey
Community Support
Hi RanjanThammaiah ,
If I understand you correctly, you can try these two workarounds:
1. Change the code like this:
let Query1 = #table({"ParameterCloseDate"},{{#"LatestWeek"}}) in Query12. Or, you can just keep "LatestWeek" parameter "Enable load". Then you can use it in Power BI Desktop.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
