Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 🙂
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |