Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX FUNCTIONS

Hello everyone!   I need a help with some Dax Fuction.  I have some collums with the name of people, start date and end date and with this I need to show the people will be available immedietaly, ...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

    Please check the below picture and the attached pbix file.

    I hope the below can provide some ideas on how to create a solution for your dataset.

     

     

    Available name measure: = 
VAR _occupiedlist =
    SUMMARIZE (
        FILTER (
            Data,
            Data[End date] >= MIN ( 'Calendar'[Date] )
                && Data[Start date] <= MAX ( 'Calendar'[Date] )
        ),
        Data[Name]
    )
VAR _otherlist =
    EXCEPT ( ALL ( Data[Name] ), _occupiedlist )
RETURN
    CONCATENATEX ( _otherlist, Data[Name], ", " )

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

Hi,

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope the below can provide some ideas on how to create a solution for your dataset.

 

 

Available name measure: = 
VAR _occupiedlist =
    SUMMARIZE (
        FILTER (
            Data,
            Data[End date] >= MIN ( 'Calendar'[Date] )
                && Data[Start date] <= MAX ( 'Calendar'[Date] )
        ),
        Data[Name]
    )
VAR _otherlist =
    EXCEPT ( ALL ( Data[Name] ), _occupiedlist )
RETURN
    CONCATENATEX ( _otherlist, Data[Name], ", " )