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.
I need a matrix that display the last 6 MonthYear when selected. The formula gives me the totals by column and not by row and I need them.
Can you help me with the formula below to give me too the totals by row.
Note: I´ve created a secondary calendar (Presentation Calendar) to help me with the formula.
Focusedlast6Months=
VAR CurrentDate =
MAX ( 'DIM Calendar'[date] )
VAR PreviousDate =
EOMONTH ( CurrentDate, -6 )
VAR Result =
IF (
HASONEVALUE ( 'Presentation Calendar'[MONTH_YEAR] )
&& MAX ( 'Presentation Calendar'[Date] ) <= CurrentDate
&& MIN ( 'Presentation Calendar'[Date] ) > PreviousDate,
CALCULATE (
'OVERALL&INTERACTIONS'[% Focused Average],
FILTER (
ALL ( 'DIM Calendar'[MONTH_YEAR] ),
'DIM Calendar'[MONTH_YEAR] = VALUES ( 'Presentation Calendar'[MONTH_YEAR] )
)
),
BLANK ()
)
RETURN
Result
Thank you
@rmeng , refer my video, when select one date/period, how to disply more than one date/period
https://youtu.be/44fGGmg9fHI?list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
Thanks for the video I´ve watched and created a formula, but still don´t work, April shouldn´t be there. If I select March 2021 the month year to be display should be Mar2021, Feb2021,Jan2021, Dec2020, Nov2020, Oct2020.
This is my formula but still don´t work:
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |