DAX FUNCTIONS

[Anonymous]

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, and in a week, month, 2 months, 3 months in a card format. 

[v-cazheng-msft]

Hi @Anonymous,

Not very clear about your needs. May I know whether you still have problem after trying the solution from Jihwan_Kim? If so, please make your needs clearer. Thanks in advance!

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please let me know. Thanks a lot!

Best Regards,

Community Support Team _ Caiyun

[Jihwan_Kim · Accepted solution]

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], ", " )