Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everyone i have this graphic made with those datas and i would like to class it month by month but advanced filter don't help me to do that, i don't know if it's useful but i have a calendar i have also tried this but it didn't worked do you have a solution?
Other any solutions is welcome too
In this scenario, you already have a calendar table with date. To have to data group on month, you can add "Year-Month" and "Month Number" column in your calendar table. See: HOW TO CREATE A DATE TABLE IN POWER BI IN 2 SIMPLE STEPS
The issue mentioned in error message should be on "Date[Date].[Month]<=Max(Date[Date])". Don't use a month compare with a date directly. I'm not quite clear about your logic. It seems the comparison in your calculatioin filter should be on date level. It will be aggregate on Month level if you add those Month/Year-Month column as @MattAllington suggested. And if you want to compare month, it's better to use MONTH() function on date which returns integer values.
Regards,
Thanks i tried this function "Dax comparaison don't take care about Text values with date values but i don't have any text values in my function, i'm using Nombre and the calendar the only text i have come from CT but i need it what can i do?
Yes a calendar is good. You need time intelligence. Read my articl ehere
http://exceleratorbi.com.au/dax-time-intelligence-beginners/
Actually, maybe all you need I see a calendar table with a column called month. For each date just have the month name and then use that's on your chart.
User | Count |
---|---|
125 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |