Forum Discussion

amandabus21's avatar
amandabus21
Icon for Helper V rankHelper V
3 years ago

DAX Parameters

Hello,    How can I create Parameters for Correct Date and Segmentt  with the "treat as"  statements in my query.    I am trying to bring this DAX statement from my power BI desktop to power bi r...
Need Help
ppm1's avatar
ppm1
Icon for Solution Sage rankSolution Sage
3 years ago

Create your datasource and then go into the Query Designer to create your dataset, paste your DAX, create your two parameters with the button in the ribbon, and then update your DAX with those names with @.

 

 

VAR __DS0FilterTable2 =
TREATAS({@DateParam}, 'data TOSAIncident'[Correct date])

VAR __DS0FilterTable3 =
TREATAS({@CityParam}, 'def TrolleySegments'[Segment Name])

 

I got an error at first when I tried it a different way, but it worked when I used the designer.

 

Pat