Hello, I posted this in another message but can't seem to get a response from the Microsoft team beyone the first reply.
I need to filter reports automatically based on the current date being the current fiscal period. There are 13 fiscal periods in the year consisting of 4 weeks. All of the formulas I have found refer to adjusted Year, Quarter, Months. I cannot find any references to fiscal period that is not Year, Quarter, Month.
I have a DimDate table with the date, fiscal period roundup(week in year / 4), and Today which is true or false depending on the current date.
I cannot figure out how to create a column that does the same as Today but for the Fiscal Period. I want to be able to drag this measure into my reports to automatically filter to the current period and then change to next period when the date falls into that fiscal period.
Solved! Go to Solution.
Try something like
VAR TodaysPeriod = MINX(FILTER(DimDate, DimDate[Date] = TODAY()), DimDate[Fiscal Period])
IF( [Fiscal Period] = TodaysPeriod, TRUE(), FALSE() )
This assumes that [Fiscal Period] is a numeric field that wil work with MINX. If its a text field, just use CONCATENATEX instead of MINX.