Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
VVlachos
New Member

Calculated Group Visual Problem

So I have a calculated group that I calculate current season and last season but I want when I drop the measure in a matrix I want to have net revenue current season side by side net revenue last season, room night current season side by side room night last season. Its like i want to reverse the 2 headers, to have Name at the top and above have the selected. Does anybody knows how i can do that?


Hope I make it understandable.

VVlachos_1-1701875594525.png

This is the  Item into the Calculation Group:

VAR hel = SELECTEDVALUE ( 'Season (2)'[SeasonalYear] )  RETURN CALCULATE( SELECTEDMEASURE(), ReservationLine, ReservationLine[SeasonalYear] = hel, 'Hotel Budget'[SeasonalYear] = hel ) 

and this is the  item into the same Calculation Group:

VAR hel = SELECTEDVALUE ( 'Season (2)'[SeasonalYear] ) VAR hel1 = hel - 1  VAR hel2 = YEAR ( TODAY () ) VAR hel3 = IF ( hel > hel2, DATE ( YEAR ( TODAY () ) - 1, MONTH ( TODAY () ), DAY ( TODAY () ) ), DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), DAY ( TODAY () ) ) ) RETURN CALCULATE( SELECTEDMEASURE(), 'Calendar Reservation'[Date] <= hel3, ReservationLine, ReservationLine[SeasonalYear] = hel1, 'Hotel Budget'[SeasonalYear] = hel1 )

 

1 REPLY 1
LGV
New Member

I have the same problem...

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.