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.
Hi,
I'm trying to make sure that when I filter the month, the table returns the 5 months before that filtered month.
I'm new to dax language and I don't have so much advanced knowledge and I found a way to solve this link:
https://towardsdatascience.com/override-date-filter-in-power-bi-743b9e8b9b2
What I did was create this measure
Value of docs -5 month = VAR MaxDate = MAX (Date [Date])
VAR MinDate = DATE (YEAR (MaxDate), MONTH (MaxDate) -5, DAY (MaxDate))
VAR Result = CALCULATE (
DISTINCTCOUNT (Table [DOC_ID]),
FILTER (table,
table [Date]> = MinDate && table [Date] <= MaxDate)
)
RETURN
Result
the table [data] is the main date of my data table
and the date [date] is a table just like the date, as if it were a fatto table
You are returning the last 5 months regarding the maximum date not what was filtered, how would you do this measure to solve this?
try changing the filter in your return to this
FILTER ( all(table) ,Table [Date]> = MinDate && table [Date] <= MaxDate)
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
42 | |
33 | |
30 | |
18 | |
18 |