topic Aprendizado em DAX in DAX Commands and Tips

Aprendizado em DAX

M4rc3l0 — Fri, 09 Aug 2024 15:49:17 GMT

Esperava que a medida DAX a seguir retornasse algo diferente:

SalasBlocosDisponiveis =

VAR SelectedDia = SELECTEDVALUE(Semana[Dia])

VAR SelectedInicio = SELECTEDVALUE(Intervalos[Inicio])

VAR EmUso =

SELECTCOLUMNS(

FILTER(

Ensalamento,

Ensalamento[Dia] = SelectedDia &&

Ensalamento[Inicio] = SelectedInicio

"Bloco", Ensalamento[Bloco],

"Curso", Ensalamento[Curso],

"Dia", Ensalamento[Dia],

"Docente", Ensalamento[Docente],

"Fim", Ensalamento[Fim],

"Inicio", Ensalamento[Inicio],

"Oferta", Ensalamento[Oferta],

"Sala", Ensalamento[Sala],

"Sem./Ano", Ensalamento[Sem./Ano],

"UC", Ensalamento[UC]

)

VAR SalasBlocosOcupados =

SELECTCOLUMNS(EmUso, "Sala", [Sala], "Bloco", [Bloco])

VAR SalasBlocosDisponiveis =

EXCEPT(

SELECTCOLUMNS(

Ambiente,

"Sala", Ambiente[Sala],

"Bloco", Ambiente[Bl]

SalasBlocosOcupados

)

RETURN

IF(

COUNTROWS(SalasBlocosDisponiveis) = 0,

"Não há sala disponível",

CONCATENATEX(SalasBlocosDisponiveis, [Bloco] & " - " & [Sala], ", ")

)

Preciso que, a partir da informação de hora de início e do dia, a medida verifique qual das salas relacionadas na tabela

'Ambiente' não constam na tabela 'Ensalamento'. Isto não está acontecendo, não sei por quê!
Por favor, ajudem-me!

Re: Aprendizado em DAX

lbendlin — Fri, 09 Aug 2024 23:56:23 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Aprendizado em DAX

M4rc3l0 — Fri, 30 Aug 2024 13:58:39 GMT

I need to create a routine in Power BI that returns information about whether or not a room is available, based on a query in two tables. Steps: 1) the user will select the "day of the week" field and the "start time" field from the "Sitting room" table; 2) from the "Sitting room" table, the system will return all the "Room" and "Block" fields found; 3) then, the system should query the "Rooms" table, using the "Room" and "Block" fields from the "Sitting room" table as the primary key, compare the fields and return all the "Room" and "Block" fields from the "Rooms" table that do not appear in the query. In short: the routine should inform which room is available at a time and on a day of the week defined by the user.

Re: Aprendizado em DAX

lbendlin — Fri, 30 Aug 2024 14:01:39 GMT

Second request: Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Aprendizado em DAX

M4rc3l0 — Fri, 30 Aug 2024 14:01:43 GMT

The expected result is that you can manage the availability or not of classrooms, distributed in different buildings, in a school.

Re: Aprendizado em DAX

lbendlin — Fri, 30 Aug 2024 14:04:25 GMT

I cannot assist you if you are unable to provide sample data. I hope someone else can help you further.

Re: Aprendizado em DAX

M4rc3l0 — Fri, 30 Aug 2024 14:39:53 GMT

The following table is called "Classrooms". It contains data on classrooms occupied on a given day of the week and in a given time range.

Unit	weekday	time range	building	classroom
Grupo Vocal e Instrumental VI	Segunda-feira	09:10 - 10:40	B3	Laboratório Música
Grupo Vocal e Instrumental VI	Segunda-feira	11:00 - 12:30	B3	Laboratório Música
Tutoria	Segunda-feira	07:20 - 08:50	NI	NI
Linguagens da cena IV	Segunda-feira	19:20 - 20:05	B2	Laboratório Corpo em Movimento 2
Linguagens da cena IV	Segunda-feira	20:05 - 20:50	B2	Laboratório Corpo em Movimento 2
Linguagens da cena IV	Segunda-feira	21:00 - 21:45	B2	Laboratório Corpo em Movimento 2
Linguagens da cena IV	Segunda-feira	21:45 - 22:30	B2	Laboratório Corpo em Movimento 2
Linguagens da cena II	Terça-feira	19:20 - 20:05	B2	Laboratório Corpo em Movimento 1
Linguagens da cena II	Terça-feira	20:05 - 20:50	B2	Laboratório Corpo em Movimento 1
Linguagens da cena II	Terça-feira	21:00 - 21:45	B2	Laboratório Corpo em Movimento 1
Linguagens da cena II	Terça-feira	21:45 - 22:30	B2	Laboratório Corpo em Movimento 1

The following table is called "Environments". It contains data for all available classrooms in different buildings:

Bl	Sala
B1	Laboratório Audiovisual
B2	EAD
B2	Laboratório Biologia
B2	Laboratório Corpo em Movimento 01 - Artes
B2	Laboratório Corpo em Movimento 02 - Ed. Física
B3	Laboratório Música
B3	Análise Sensorial

When the user selects the variable "Monday" in the "weekday" field and the variable "09:10 - 10:40" in the "time range" field, it will return that the classroom 'Music Lab' in building 'B3' is occupied.
The routine should query the "Environments" table, using the fields "Classroom" and "Building" as the primary key, and return all the "Classrooms" that are available. In this example, "B1 - Laboratorio Audiovisual"; "B2 - EAD"; "B2 - Laboratorio Biologia" and so on.