topic Re: DAX FUNCTIONS in DAX Commands and Tips

DAX FUNCTIONS

Anonymous — Fri, 02 Sep 2022 18:16:19 GMT

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.

Re: DAX FUNCTIONS

Jihwan_Kim — Sat, 03 Sep 2022 08:29:41 GMT

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

Re: DAX FUNCTIONS

v-cazheng-msft — Tue, 06 Sep 2022 05:41:00 GMT

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