topic Re: Can' assign table elements to variables in DAX Commands and Tips

Can' assign table elements to variables

IgorKaradzic — Thu, 14 Mar 2024 07:41:07 GMT

Hi guys,

i am trying to assign for example VAR test = 'Query1'[Field] but it doesn' work. Erorr is can't find name 'Field' but i know for a fact that it exists and i'm not spelling it wrong. Can anybody help me with this?

Thank you.

Re: Can' assign table elements to variables

some_bih — Thu, 14 Mar 2024 07:46:43 GMT

Hi IgorKaradzic probaj

VAR test =SELECTEDVALUE('Query1'[Field])

ili neku agregatnu kao MIN / MAX zavisno šta ti treba 🙂

Re: Can' assign table elements to variables

Dangar332 — Thu, 14 Mar 2024 07:47:43 GMT

hi, IgorKaradzic

if its measure then need to provide aggregation function like

min(),max(),sum()...

so maybe try with VAR test = min('Query1'[Field])

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Can' assign table elements to variables

IgorKaradzic — Thu, 14 Mar 2024 08:00:05 GMT

Nazalost, ni ovo ne radi. Sad pored inicijalnog errora pokazuje i nov tip errora da parametar nije odgovarajuceg tipa. Zaboravio sam da napomenem da je Field polje tekstualni tip.

Re: Can' assign table elements to variables

IgorKaradzic — Thu, 14 Mar 2024 08:00:43 GMT

I don't need min or max. I need currently selected value.

Re: Can' assign table elements to variables

some_bih — Thu, 14 Mar 2024 08:02:33 GMT

Hi / pozdrav IgorKaradzic

We need more details about your model / tables / relationships between tables and columns and when you plan to use this field, to provide some possible solution.

Re: Can' assign table elements to variables

IgorKaradzic — Thu, 14 Mar 2024 08:08:16 GMT

My overall goal with this task is to compare task id's inside same column and if the are the same check if time for the tasks overlap. They are in Month, Date, Year format.

Re: Can' assign table elements to variables

IgorKaradzic — Thu, 14 Mar 2024 08:25:40 GMT

Here is example table

ID Task Responsible	Planned Start Date	Planned Finish Date
1	13.3.2024.	23.3.2024.
2	23.3.2024.	25.3.2024.
2	25.3.2024.	1.4.2024.
2	25.3.2024.	29.3.2024.
2	29.3.2024.	7.4.2024.
2	7.4.2024.	10.4.2024.

Re: Can' assign table elements to variables

some_bih — Thu, 14 Mar 2024 08:36:11 GMT

Hi IgorKaradzic what is your request for possible solution: calculate something and also on your example table there is no [Field] (reference to your initial post: Query1'[Field] but it doesn' work. Erorr is can't find name 'Field' )

Re: Can' assign table elements to variables

IgorKaradzic — Thu, 14 Mar 2024 08:38:57 GMT

That's what is says in error message. I sent you example table down bellow.

Re: Can' assign table elements to variables

IgorKaradzic — Thu, 14 Mar 2024 08:39:15 GMT

ID Task Responsible	Planned Start Date	Planned Finish Date
1	13.3.2024.	23.3.2024.
2	23.3.2024.	25.3.2024.
2	25.3.2024.	1.4.2024.
2	25.3.2024.	29.3.2024.
2	29.3.2024.	7.4.2024.
2	7.4.2024.	10.4.2024.

Re: Can' assign table elements to variables

some_bih — Thu, 14 Mar 2024 08:43:44 GMT

Hi IgorKaradzic I am sorry, I do not understand your issue based on information from your side.

Re: Can' assign table elements to variables

IgorKaradzic — Thu, 14 Mar 2024 09:11:11 GMT

First i would like to compare data from column ID Task Responsible. First row from that column with second row, then second row with third row and so on. If they are not equal then do nothing. If they are equal, we must check if there is overlaping in dates. If there is, then i must for example add 5 hours to second compared row. We must do that for each 2 rows like i mentioned. Is it possible to do something like that?

Re: Can' assign table elements to variables

some_bih — Thu, 14 Mar 2024 09:23:15 GMT

Hi IgorKaradzic "comparing" row by row for same column could be tricky as you have same (not unique) in column ID.

Why don't you use column Planned Finish Date in your calculation logic, if possible?

Re: Can' assign table elements to variables

IgorKaradzic — Thu, 14 Mar 2024 09:32:35 GMT

To rephrase mi initial input, the result of this exercise is to show which dates are overlaping for the same task so the next task can't start during the previous. Basically i want to have another column generated where it suggests the start date of the overlaping task is in form of finished date of previous task + 1 day.

Re: Can' assign table elements to variables

some_bih — Thu, 14 Mar 2024 09:40:04 GMT

Hi IgorKaradzic

So one of output is which date is not overlaping (not task for that date active or similar...)? It would be view per date?

How you define overlaping? Two and more distinct ID per task or ...?

What is desired output for table above (in than one or more new columns)

Re: Can' assign table elements to variables

IgorKaradzic — Thu, 14 Mar 2024 09:48:36 GMT

ID Task Responsible	Task	Planned Start Date	Planned Finish Date
1	Task1	13.3.2024.	23.3.2024.
2	Task2	23.3.2024.	25.3.2024.
2	Task3	25.3.2024.	1.4.2024.
2	Task4	25.3.2024.	29.3.2024.
2	Task5	29.3.2024.	7.4.2024.
2	Task6	7.4.2024.	10.4.2024.

Overlaping is where one employee works on different tasks simultaneously as you can see from this table.

Re: Can' assign table elements to variables

some_bih — Thu, 14 Mar 2024 10:39:46 GMT

Hi IgorKaradzic

I understand that Task colum and column Planned Finish Date are critical input for new column NextDateForTask with definition below.

It could be that another column is key inputs as your simple example do not have some expected output.

Check it with your real data.

NextDateForTask =

--assuming Task is column criteria for max date

CALCULATE(

MAX(Sheet1[Planned Finish Date]),

ALLEXCEPT(Sheet1,Sheet1[Task])

)+1--adding one single date for start next task

Output

Re: Can' assign table elements to variables

IgorKaradzic — Wed, 20 Mar 2024 06:41:54 GMT

Hello, sorry for not answering earlier but this is still not the solution i am looking for. It's close but not it. Thank you for your help.

Re: Can' assign table elements to variables

some_bih — Wed, 20 Mar 2024 06:48:15 GMT

Hi IgorKaradzic

I expected your last answer as I did not know what inputs are and at which level to provide calculated column works as you want.