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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors