Forum Discussion

MPG1907's avatar
MPG1907
New Member
2 years ago
Solved

undefined

Hi I am new to Power BI. I need to analyse data about language classes attendance. I need to analyse how many people attended each class each month, their nationality and gender for last 5 years. Do ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hola MPG1907. Recomiendo que crees dos consultas adicionales.

    La primera, una consulta que sea Class code, para poder relacionar con Class Sub-Code, debes quitarle los numeros a partir del guion medio.

     

    Y la segunda tabla, es la tabla calendario. Con este formula DAX la puedes crear:

     

    TablaCalendario =
    VAR T_Calendario =
        ADDCOLUMNS(
            CALENDARAUTO(),
            "Año", YEAR([Date]),
            "Semestre", "Semes. " & CEILING(MONTH([Date])/6, 1),
            "Cuatrimestre", "Cuatr. " & CEILING(MONTH([Date])/4, 1),
            "Trimestre", "Trim. " & CEILING(MONTH([Date])/3, 1),
            "Bimestre", "Bim. " & CEILING(MONTH([Date])/2, 1),
            "Mes Número", MONTH([Date]),
            "Mes Nombre", FORMAT([Date], "MMMM"),
            "Semana", "Sem. " & WEEKNUM([Date], 2),  -- El número 2 indica que la semana comienza en lunes
            "Día Número", WEEKDAY([Date],2),
            "Día Nombre", FORMAT([Date], "dddd")
        )
    RETURN
        T_Calendario
     
    Si está satisfecho con esta respuesta, márquela como solución para que otros la encuentren.
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi MPG1907 ,

     

    First of all, thank you andrezmar and qqqqqwwwweeerrr for the quick reply. 

    I have some other ideas for you to consider. Based on your test data, I think a pie chart would be a good option for you. You can visualize the various percentages.

    If you want to display the most popular Activity name as a visual object of the card then you can create measures.

     

    Measure = COUNT('classes delivered in 2023'[Activity name])
    Measure 2 = 
var _table=SUMMARIZE(ALL('classes delivered in 2023'),[Activity name],"count",[Measure])
var _max= MAXX(_table,[count])
RETURN MAXX(FILTER(_table,[count]=_max),[Activity name])

     

     

    Best Regards,

    Neeko Tang

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi MPG1907 ,

 

First of all, thank you andrezmar and qqqqqwwwweeerrr for the quick reply. 

I have some other ideas for you to consider. Based on your test data, I think a pie chart would be a good option for you. You can visualize the various percentages.

If you want to display the most popular Activity name as a visual object of the card then you can create measures.

 

Measure = COUNT('classes delivered in 2023'[Activity name])
Measure 2 = 
var _table=SUMMARIZE(ALL('classes delivered in 2023'),[Activity name],"count",[Measure])
var _max= MAXX(_table,[count])
RETURN MAXX(FILTER(_table,[count]=_max),[Activity name])

 

 

Best Regards,

Neeko Tang

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