If you have multiple datasources, and one has a different one, than you may use a calc. field that writes something like,
IIF(datediff('day',datetrunc('month',[process_date]),[process_date])>=7,"last month data","the month before data")
not sure how your data structure is set up (what your measures are etc) but hope you got the idea.
Thank you for following up on my question. How do I employ the calc in the view? This is what I'm looking at right now:
Just to clarify I am trying to show 2 months previously until the 7th of the actual month. In other words, I have other files in the dashboard that update at the beginning of the month with last month's information but I have one data source that doesn't populate last month's data until the 7th of the current month.
I'm trying to set the calculation so the filter shows two month's prior until the 7th when it should go to last month prior because if its set to show "Last Month" its wrong and blank for the first 7 days of the month because there isn't any data yet.
Please let me know and thank you for your help!