Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |