Paginated Report - From and To Date Range Parameter

I have a paginated report that points to a dataset. I have a filter on the date in the date dimension table using range inclusive option. This creates my from and to date parameters. These from and to date parameters are set as text because the dax query has logic to conver to datetime to do the comparison. My report runs and returns data, but it always returns data just for the date that is the 'to' date. i.e, if I select the from as 6/30/2022 and the to as 8/31/2022, the report only returns ddata for 8/31/2022 even though I know there is data for other months. I can run it for other months, and it always returns data just for the 'to' date. I even changed the date parms to date/time and still get the same results. Any ideas why? I have researched this a lot and tried many things but no success. Thanks



Comments

Popular posts from this blog

Spring Elasticsearch Operations

Network Error and Timeout on Authorize.net JS

Object oriented programming concepts (OOPs)