Looking to exclude items with no total

[GarryA]

@benwann1 @sam.mckay @Melissa it’s been asked before here. Plus Sam has date tables in his resources and a bunch of videos on this.

Here are the answer’s from Sam and Melissa which are on the money. :)

Calendar for current month and future 11 months

Yes nice one Melissa, You can solve it in the date table quite easily with a new column. You could also do this with a calculated column as well. For question 2 (in future can we place different questions in different forum posts) This is quite easy as well. I think you just want to select both at the same time. I don’t think you really need to create anything new. The user should just be able to see that they can select multiple items in the slicer. This way they can have the flexibility to …

So just further to this, the current month needs the current date worked out in your date table logic first.

CurrentDate = DateTime.Date(DateTime.FixedLocalNow()),

Then you can add the current month offset m-code to your calendar query like this from the advanced editor window.

CurrentMonthOffset = Table.AddColumn(PreviousStepName, “CurrentMonthOffset”, each (Date.Year([Date])- Date.Year(CurrentDate) ) * 12 + Date.Month([Date]) - Date.Month(CurrentDate), Int64.Type),

This will extract the relevant month number of the current month.