Help required understanding how to implement NullSteps

tbablue

Active Member
Joined
Apr 29, 2007
Messages
488
Office Version
  1. 365
Platform
  1. Windows
Hi forum,

I'm trying to implement parameters into my Power Query. I can manage without issue when I enter a parameter - I can manage when I introduce a NullStep for a single parameter - but I'm struggling to implement multiple parameters with multiple NullSteps. Any assistance would be welcome.

This is my query in full...

Power Query:
let
    Source = #"RAW Cost Transaction Data Drop",

    //Variables
    //
    Project = Project_Picker,
    from = Picker_From,
    to = Picker_To,

    //Processing Data
    //
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Period", type text}}),
    #"Added Prefix" = Table.TransformColumns(#"Changed Type", {{"Period", each "0" & _, type text}}),
    #"Extracted Last Characters" = Table.TransformColumns(#"Added Prefix", {{"Period", each Text.End(_, 2), type text}}),
    #"Merged Columns" = Table.CombineColumns(Table.TransformColumnTypes(#"Extracted Last Characters", {{"Year", type text}}, "en-GB"),{"Year", "Period"},Combiner.CombineTextByDelimiter(".", QuoteStyle.None),"Reporting Period"),
    #"Duplicated Column" = Table.DuplicateColumn(#"Merged Columns", "Reporting Period", "Reporting Period - Copy"),
    #"Changed Type1" = Table.TransformColumnTypes(#"Duplicated Column",{{"Reporting Period - Copy", type date}}),
    #"Reordered Columns" = Table.ReorderColumns(#"Changed Type1",{"Control Account ID", "Project", "Text Between Delimiters", "Activity", "Project Description", "Transaction Date", "Time", "WBS Description", "Cost Type", "Cost Object", "Cost Obj Desc.", "Description", "Cost Component", "Cost Comp Desc.", "Employee", "Employee name", "Labor Type", ".", "Origin", "Posting Type", "Document", "._1", "Quantity", "Units", "Project Cost", "Currency", "Financial Document", "._2", "._3", "._4", "._5", "Document Number", "Post to Finance", "Transaction Origin", "Financial Transaction", "Cost Control Period", "Reporting Period", "Reporting Period - Copy", "Hours Control Period (wk)", "..", ".._6", "Include?"}),
    #"Removed Columns" = Table.RemoveColumns(#"Reordered Columns",{"Hours Control Period (wk)", "..", ".._6", "Include?", "Cost Control Period", "Post to Finance", "Financial Document", "._2", "._3", "._4", "._5", "Document Number", ".", "Labor Type", "Cost Component", "Cost Object", "Time", "Text Between Delimiters", "Activity", "Project Description"}),
    #"Filtered Rows" = Table.SelectRows(#"Removed Columns", each ([Project] = Project)),
    #"Filtered Rows1" = Table.SelectRows(NullStepTo, each [#"Reporting Period - Copy"] >= from),
    #"Filtered Rows2" = Table.SelectRows(NullStepTo, each [#"Reporting Period - Copy"] <= from),

    //NullSteps
    //
    NullStepProject = if Project_Picker<>null then #"Filtered Rows" else #"Removed Columns",
    NullStepFrom = if Picker_From<>null then NullStepProject else #"Filtered Rows2",
    NullStepTo = if Picker_To <> null then NullStepFrom else #"Filtered Rows2"

in
    NullStepTo



I keep getting the following error message...
Expression.Error: A cyclic reference was encountered during evaluation.

Thanks again for your time, attention, and expertise. Most grateful.
 
Last edited by a moderator:

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top