Forum Discussion
Paginated report working PB dataset
I have been given a PB dataset to build a report on.
DAX is not my strongest skill, so I am having difficulties pulling data into report's datasets.
For example, I have a date column. I need to pull data from that dimesion where the date is within 90 days from the latest date. Not ssure how to do that. Any idea?
Thanks
1 Reply
Hi Markzolotoy
When creating the dataset in Paginated reports, you can use the GUI to put in the fields you want and then use the parameters at the top to define which parameters you want to use.
I would suggest asking the person who created the dataset to create a column in the date table which has got the last 90 days. You can then use the column in your parameters to automatically select the past 90 days.
Here is a tutorial on how to possibly do this: Create a paginated report with a Power BI shared dataset - Power BI Report Builder - Power BI | Microsoft Docs
