Forum Discussion
Using a Relative Time Stamp (MM/DD/YYYY HH:MM:SS) filter to set start and end fiscal month?
Anonymous Sorry, but I am not sure if I am following.
I am using a calendar table, and it does have a relationship to the timestamp value being used. Filtering on fiscal year(s) within this calendar table only reduces the amount of days/dates available in the relative date slicer. It does not address my issue of needing to make things filterable by fiscal month instead of fiscal day.
As far as creating a calculated column to extract only the MM-YYYY portion of the timestamp, that seems promising. But I am battling issues. When I go to use a formula such as (format(date[date],"MM-YYYY"), dax won't even let me select the datestamp dimension within the date brackets. I.e. it is not a selectable option.
Thoughts?
Solution SageCan you post a small sample file... power bi can be a little different than excel in refering to values in columns
unfortunately, my corporation does not allow me to upload/share files.
all I can do is suggest solutions that I think will work, but I have struggled with...
for example, I have a field connected to the timestamp called 'monthnyear' that is basically in the format I need it. Issue is, it is not able to be leveraged in a relative filter.
It is not like I can create two simple dropdowns called "min monthnyear select" and "max monthnyear select" and have the data filter between the values. That would be ideal, but I'm not aware of a way to make that happen.