Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello guys,
I'm new in powerBI and Im' facing a problem.
Please help!
The X column is a calculated column that I drag it to the table (the sum is enabled) and it's doing the sum of the values basing on the selected Month (Less then or equal to slicer) -> it's working fine
The column Y and Z are a measures, they sould sum the values where the month is = selectedMonth (Not less then or equal)
I used this formula for the Y and Z column :
Solved! Go to Solution.
The issue is with crossfiltering. You should create a date table (and create a relationship to your tab table) and filter to max month using the date table. The measure would then look something like this:
The issue is with crossfiltering. You should create a date table (and create a relationship to your tab table) and filter to max month using the date table. The measure would then look something like this:
Thank u so much for your quick response.
This helped me a lot.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
28 | |
11 | |
11 | |
10 | |
6 |