cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Syndicate_Admin
Administrator
Administrator

Convertir la tabla de 3 pasos en una sola tabla mediante la función CALCULATETABLE

Soy nuevo en DAX y tengo una tarea que requiere que simplifique la tabla de 3 pasos a una sola tabla usando la función CALCULATETABLE en DAX.

He estado probando esto durante casi 2 semanas, todavía no puedo tener la idea.
¿Alguien sabe cómo puedo simplificar estos pasos a una sola tabla usando la función CALCULATETABLE?

Gracias

Tabla 1:

forecasting_uoa_transactions_step1 = 
    FILTER (  
        SUMMARIZE ( 
            uoa_transactions_history, 
            uoa_transactions_history[Date], 
            uoa_transactions_history[Country], 
            "UoA", SUM(uoa_transactions_history[Total Changes])
        ),  
        DATEDIFF(uoa_transactions_history[Date],TODAY(),MONTH)<variable_uoa_per_cust_window[Variable_UoA_per_Cust_Window Value]+1
    )


Tabla 2:

forecasting_uoa_transactions_step2 = 
    SUMMARIZE ( 
        forecasting_uoa_transactions_step1, 
        forecasting_uoa_transactions_step1[Country],
        "UoA Per Customer Average", AVERAGE(forecasting_uoa_transactions_step1[UoA_per_Customer])
    )


Tabla 3:

forecasting_uoa_transactions_step3 = 
    SELECTCOLUMNS ( 
        customer_transactions_forecast,
        "Date", customer_transactions_forecast[YearMonth],
        "Country", customer_transactions_forecast[Country],
        "Customers", customer_transactions_forecast[Total Headcount]
    )

0 REPLIES 0

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!