Forum Discussion
User Input is not recognized in DAX formula
Hi all, I am a newbie and want to create a report with different sets of criteria, based on user input. The input value appear fine on the dashboard and in the report table but in formulas, it se...
I forgot to mention that we have done exactly what we need to do but it is on the desktop version where we have parameters or changing the SQL in the report that controls the logic going back to the database source, i.e. "WHERE (SOURCE = 'VW1' and PER <= &&PERIOD) OR (SOURCE = 'VW2' and PER = &&PERIOD)". But by doing that, we need to have that desktop going through the firewall to the database source.
Now we are exploring using the online version where users only have access through the gateway and do not have access to parameters that control the criteria of the data query. All logics must be contained within Power BI and this task has been a challenge, hence my post. Can this be done in Power BI?