• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

To bring a table only to today' date

jutu

Member
Hi. Let's say we have a DimDate table with future dates. What would be the best way to only bring dates up to today? I thought of may be creating a customize column but not how to approach it and not sure it would work. I cannot filter a table up to today's dates only can I? Please note that, at least in my PBI version I do not have the option "is before or equal to..." when I right click on the dates column
 
I cannot filter a table up to today's dates only can I?
I think you can, best attach a little workook with this in.

By the way, if the table only has 'future dates' then there won't be any 'dates up to today'!
 
Hi. Let's say we have a DimDate table with future dates. What would be the best way to only bring dates up to today? I thought of may be creating a customize column but not how to approach it and not sure it would work. I cannot filter a table up to today's dates only can I? Please note that, at least in my PBI version I do not have the option "is before or equal to..." when I right click on the dates column
How do you make this calendar table?
With PQ then you can filter using less then or equal to today. Use the date filter options using is today. Then tweak the formula.
If you use DAX you can use variables. That pattern is explained by many. A simple Google search will help.
 
Don't ever filter DimDate table. Time intelligence will not behave correctly when full year dates are not in date dimension table(s).

Always apply filter on Fact table. Do this in PQ using "= Date.From(DateTime.FixedLocalNow())"

However, I can't really imagine fact table having future dates... unless you got some forecasting/targets as fact table.
If you want to remove future date from measures. You can always use DAX pattern [DateColumn]<=Today() as one of filter arguments.
 
Back
Top