Forum Discussion
Dynamic Filter by Today's Period/Date
Sample File https://drive.google.com/file/d/1lysTi_VPXBGhGB1WUF05BDdF6DWOxUhE/view?usp=sharing I have a date calendar table, and my Sales Table has an "Accounting Period" and "Shipped Date" Co...
Since I made today a calculated column, I believe it is only filtering my "Sales" Table by the "Shipped date" row that is "yes" for Today. I want it to Filter the Sales table by "accounting period" where the "shipped date" is "today's date" = yes.
So "Shipped Date" for 2021 P6 is 5/30/31 thru 7/03/2021, "shipped date" for 2022 P6 is 5/29/22- 7/02/22.
I want to dynamically filter a graphic by the period we are in today, based on today's date
Sorry if you answered that, I was just a little confused
I attached link with some PBIX sample file data from my report.
https://drive.google.com/file/d/1lysTi_VPXBGhGB1WUF05BDdF6DWOxUhE/view?usp=sharing