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.
How can I do to disappear with the months highlighted as shown below?
I don't need the future dates (oct to dec 2020).
My DAX for the one measure used in this axis:
Thanks in advance.
Marcos
Solved! Go to Solution.
@Anonymous - Use MIN instead of MAX
@Anonymous , another way out is
if( max('tb_aog'[INICIO].[Date]) >= Eomonth(today()-1) , blank(),
Great!! Thank you @amitchandak and @Greg_Deckler for your attention on this matter. Super helpful!!
Have you guys a great day!
Great!! Saved my day!! Fixed
@Anonymous , another way out is
if( max('tb_aog'[INICIO].[Date]) >= Eomonth(today()-1) , blank(),
Perfect, but Sep 2020 disappeared.
@Anonymous - Use MIN instead of MAX
@Anonymous , Assuming 'tb_aog'[INICIO].[Date] is used on axis. else use the date on axis
Try
Count of events 6 MO =
if( max('tb_aog'[INICIO].[Date]) >= today(), blank(),
IF(
ISFILTERED('tb_aog'[INICIO]),
ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),
VAR __LAST_DATE = ENDOFMONTH('tb_aog'[INICIO].[Date])
VAR __DATE_PERIOD =
DATESBETWEEN(
'tb_aog'[INICIO].[Date],
STARTOFMONTH(DATEADD(__LAST_DATE, -5, MONTH)),
ENDOFMONTH(DATEADD(__LAST_DATE, 0, MONTH))
)
RETURN
IF (
YEAR ( __LAST_DATE ) IN ALLSELECTED ( tb_aog[INICIO].[Year] ),
AVERAGEX(
CALCULATETABLE(
SUMMARIZE(
VALUES('tb_aog'),
'tb_aog'[INICIO].[Year],
'tb_aog'[INICIO].[QuarterNo],
'tb_aog'[INICIO].[Quarter],
'tb_aog'[INICIO].[MonthNo],
'tb_aog'[INICIO].[Month]
),
__DATE_PERIOD
),
CALCULATE([Count of events], ALL('tb_aog'[INICIO].[Day]))
)
)) )
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 |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |