Forum Discussion
Need M code for dynamically selecting financial year start and end date picked from a slicer visual
Hi all, below is my SQL query. I have highlighted the content that needs to fetch information directly from the slicer selection of a visual. Tried for many hours but still dont want to give up. ...
edhans Actually, it is the other way around. The slicer selection should pass the values to the m code which in return fetches the data from oracle only for the specific financial year start and end dates.
Ok, sorry. I don't spend much time trying to optimize Direct Query to relational databases. Too many downsides for the overwhelming number of my projects. Someone else with more experience in that might want to jump in.