Relative date, Calendar Month... Can I get it to show this month?

[Anonymous]

Hello all,

So I'm working with the filters, and I am trying to set-up a Relative Date filter, and filter on Calandar Month, but I would like it to include this current month, but the Calendar offerings do not have the check box to Include today.  It works with the Month filter, but that keeps eroding the first month in the results as those days get added to this month, and I'd want to keep the first month complete, otherwise the figures are skewed.

Thanks in advance

[Whoaitsyu]

Did you end up resolving this? I have the exact same issue.

[v-eachen-msft]

Hi @Anonymous ,

Could you please share your sample data and excepted result if you don't have any Confidential Information? Please upload your files to OneDrive and share the link here.

[Anonymous]

Hi There!
I've spent the last couple of days going through the blog that Mariusz linked to, and my brain has dribbled out of my ear!

So I have a query that links to a couple of csv files on two servers, and they append and then there is a shed load of working on the data
So I have generated a numeric value for for duplex, and the Sheet column is Pages * Copies / Duplex_numeric which is rounded up by removing the decimal places.  SO this gives me how many sheets of paper we use.

I have then duplicated the Date_Time and made it Date_only.  So I have Sheets and I have Date Only to make my Cluster Column visual.  So I put SHeets in the Data and Date_only on the Axis, and get this...

So, I replace Date_only with Month_name from a date table called Date_Table which is linked to the printer table and I filter on Date_only, so that it only shows anything from the last 6 calendar months, but this is still far from perfect, and here is where I have spent days messing with different solutions. I have created index date tables, so get the dates in order, but None of these help when I wrap around a calander year, having the mons run Jan, Feb, Mar, Nov, Dec, and not Nov, Dec, Jan, Feb, Mar.

Tjhis is where I have been trying Mariusz blog post, and that cure the issue of being able to get this month while sticking with Calander Months, but I cannot get them in order. So I'm not sure how to progress to get the last 6 calander months in the correct order..

[az38]

Hi @Anonymous  @Whoaitsyu 

it s difficult to understand your issue correct, but I can suggest a solution to order your month

Add a calculated column into your date table like

Column YM = FORMAT([Date], "YYYYMM")

 then try to sort it with this technique

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

[Mariusz]

Hi @Anonymous 

You can use Relative date dimension as per article below.

https://community.powerbi.com/t5/Community-Blog/Relative-Date-Dimension/ba-p/779039

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Greg_Deckler]

Can you provide any more information or images?