Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi everyone,
I'm trying to create a measure that shows the Sales Contribution for just the month of Janaury but it's returning all months and not just January as per the screenshot below.
Can anybody spot where I'm going wrong with my measure? Please see it below.
The year is 2015 as that's what the sample data set provided.
Many Thanks in advance.
There's two easy options - first is to create a new column in your Date table for the month and put that in the slicer. The other would be to add a line to the filter statement for the month. something like:
FILTER(
DateTable,
...
MONTH(DateTable[Date]) = 1
),
Thank you for the response and your help 🙂