Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
casperholtfarve
Helper III
Helper III

Filtering entire report (all pages) from SSAS based on dynamic date

Hi community

I need some help! At work we are using cubes from SQL Server Analysis Services as out data foundation/model.
The issue here is, that some of the data fields do not get filled out until a couple of months later than the actual date.

 

There for what I want is a way to exclude ALL the data that has been registered for the past 2-3 months. So for example today 16th of may 2023, I want all date before or equal to the date of 28th of february 2023. When ever we get to June 1st, I want the date to become march 30th and so on.

Is there any way to do this either in filterering the data in the Cube or in the report view?

This is a snapshot of the data model. It is in danish but I have circled the actual data (red) and the date table (blue).

casperholtfarve_0-1684213982024.png


Thanks in advance



 

2 REPLIES 2
d_gosbell
Super User
Super User

I would think it would be easier to just not load the incomplete periods into the cube at all. If you had a filter in your ETL process or in a view layer that was feeding the cube (if you are loading from a relational database) that would be the easiest way of achieving this.

Hi @d_gosbell 
I think you might be right. I was just wondering whether the possibility was actually there in PBI as well. 
But I also think the cleanest way to do it would be through the ETL/loading process. Thanks 🙂

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Kudoed Authors