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 everyone,
I need to limit the data that is being shown in a graph by following this criteria:
i.e: if we are one April 7th, show up to February 28th; after April 15th show up to March 31st and so on....
I think there are many ways to accomplish this, the aproach that I am trying to follow consists of a binary measure that determines the MAX date to show data depending on the current date. A few variables let me obtain dynamically the paramenters, however I am not sure how to proceed with the logic to determine the MAX date for each case.
Perhaps that is not the best approach.
Any help is much appreciated, thanks in advance.
Regards
Solved! Go to Solution.
You use
VAR EndOfLastMonth =
EOMONTH ( TODAY (), -1 )
VAREndOfTwoMonthsAgo =
EOMONTH ( TODAY (), -2 )
VArCriteriaDate =
IF ( DAY ( TODAY () ) >= 15, EndOfLastMonth, EndOfTwoMonthsAgo )
You use
VAR EndOfLastMonth =
EOMONTH ( TODAY (), -1 )
VAREndOfTwoMonthsAgo =
EOMONTH ( TODAY (), -2 )
VArCriteriaDate =
IF ( DAY ( TODAY () ) >= 15, EndOfLastMonth, EndOfTwoMonthsAgo )
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 |