Power Query advance editor avoid repetition of same task,Reuse Transformation Steps on Another Table

Поділитися
Вставка
  • Опубліковано 22 сер 2024
  • Power Query advance editor used to avoid repetition of same task for all sheets - How to Copy & Reuse Transformation Steps on Another Table
    USE POWER QUERY TO IMPORT MULTIPLE SHEETS
    TRANSFORM UNSTRUCTERED DATA STRUCTURED DATA INTO MULTIPLE SHEETS DATA
    USE OF ADVANCE EDITOR TO USED IN ONE TABLE AND COPY PAST OR REUSE SAME STEPS OF POWER QUERY FOR OTHER TABLES TO AVOID REPETITION OF SAME STEPS
    UNDERSTAND CALCULATED COLUMN & CALCULATED FIELD , ACTIVATE CALCULATED COLUMN & CALCULATED FIELD
    DIFFERENCE PIVOT TABLE WITH DATA MODEL AND WITHOUT DATA MODEL
    ADD PIVT TABLE TO DATA MODEL
    CREATE NEW MEASURE WITHOUT POWER PIVOT
    create a comprehensive example that demonstrates the use of CONCATENATEX, FILTER, ADDCOLUMNS, and CALCULATE DAX functions in Power Pivot for Excel.
    DAX CODE AND USE SUM CONCATENEX FILTER FUCNTION
    MAKE COMPRATIVE ANALYSIS MONTH WISE PERFORMANCE IN EXCEL
    ADVANCE CONDITIONAL FORMATING BASED ON PIVOT TABLE COLUMNS

КОМЕНТАРІ • 4

  • @susannamartirosyan48
    @susannamartirosyan48 Місяць тому +2

    The music gets in the way. Remove it.

    • @eallen6387
      @eallen6387  16 днів тому

      Sorry for the inconvenience , I have to detach audio then record voice again, as it was not added with the help of youtube

  • @saifulislam-xq9wh
    @saifulislam-xq9wh 20 днів тому

    Music is annoying . Remove it and provide data set

    • @eallen6387
      @eallen6387  16 днів тому

      Sorry for the inconvenience , I have to detach audio then record voice again, as it was not added with the help of youtube