Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Filter Query by LASTDATE

When querying a data source I need to filter the rows imported by a date column. This is analytics data where many rows will have the same date, the date the metric was measured. I'd like to limit th...
Need Help
BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
9 years ago

Just to clarify your misunderstanding about DAX Functions and M Query Language. DAX is the language of PowerPivot-"The calculation Engine" of PowerBI whereas pulling the data from data source involves the Query Editor which uses the different language than DAX and informally called "M". 

Both have different syntax and have completely different functions. 

 

For Your Scenario,

 

You can use Parameters to filter the values in your "Google SERP Date" column. Watch this DEMO.