Forum Discussion

miltenburger's avatar
miltenburger
Helper V
8 years ago
Solved

Custom column advanced editor

Hi Guys,   I'm working on a project where I want to show all the reservation for meeting rooms compared with the light sensors of the meeting rooms. So, when someone makes a reservation for a meeti...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    8 years ago

    Hi miltenburger,

     

    Based on my test, we can use DAX to meet your requirement.

     

    Create a calculated table using the formula.

     

    Table = CROSSJOIN(calender,reservation)

     

    Based on the new table, we can create a calculated column.

     

    Column = IF('Table'[Startdate]='Table'[Enddate] || 'Table'[Enddate]>MAX('Table'[Timestamp]) ,BLANK(),IF('Table'[Startdate]<='Table'[Timestamp] && 'Table'[Enddate]>='Table'[Timestamp],'Table'[Room]))

     

    Then we can get the result as we need. Please note here we need to filter the blank value out.

     

     

    For more details, please check the pbix as attached.

     

    https://www.dropbox.com/s/lqv1s46i8rzl057/Custom%20column%20advanced%20editor.pbix?dl=0

     

    Regards,

    Frank

v-frfei-msft's avatar
v-frfei-msft
Community Support
8 years ago

Hi miltenburger,

 

Based on my test, we can use DAX to meet your requirement.

 

Create a calculated table using the formula.

 

Table = CROSSJOIN(calender,reservation)

 

Based on the new table, we can create a calculated column.

 

Column = IF('Table'[Startdate]='Table'[Enddate] || 'Table'[Enddate]>MAX('Table'[Timestamp]) ,BLANK(),IF('Table'[Startdate]<='Table'[Timestamp] && 'Table'[Enddate]>='Table'[Timestamp],'Table'[Room]))

 

Then we can get the result as we need. Please note here we need to filter the blank value out.

 

 

For more details, please check the pbix as attached.

 

https://www.dropbox.com/s/lqv1s46i8rzl057/Custom%20column%20advanced%20editor.pbix?dl=0

 

Regards,

Frank

miltenburger's avatar
miltenburger
Helper V
8 years ago

Ah wauw great solution,

thanks for helping me out!