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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
iioannou
Helper I
Helper I

Filtering and DAX question

Hello,

 

 

I have a very simple question and I need some help. I have this custom column

 

Occupancy % TMY = (('Almyra Rooms'[Rooms Sold (net of CPL)] * 100) / 'Almyra Rooms'[Capacity]) / 25

 

and what I want to achieve is where 25 to be the day selected from my slicer.

 

Capture12345.PNG

 

if it helps to understand what I mean you can see also the MATRIX that holds this value

 

Capture123456.PNG

 

 

 

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Occupancy % TMY = var DateDiff = DATEDIFF(
CALCULATE(MIN('Date'[Date]);ALLSELECTED('Date'[Date]));
CALCULATE(MAX('Date'[Date]);ALLSELECTED('Date'[Date]));
DAY) return (('Almyra Rooms'[Rooms Sold (net of CPL)] * 100) /
'Almyra Rooms'[Capacity]) / DateDiff)



But it will work as measure only, not as calculated column...

 

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Occupancy % TMY = var DateDiff = DATEDIFF(
CALCULATE(MIN('Date'[Date]);ALLSELECTED('Date'[Date]));
CALCULATE(MAX('Date'[Date]);ALLSELECTED('Date'[Date]));
DAY) return (('Almyra Rooms'[Rooms Sold (net of CPL)] * 100) /
'Almyra Rooms'[Capacity]) / DateDiff)



But it will work as measure only, not as calculated column...

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

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