Forum Discussion

AK92's avatar
AK92
Regular Visitor
2 years ago
Solved

Dynamic M Query - Pass SQL query as a parameter

Hi Anonymous   Looking for some expertise on a scenario that I'm trying to figure out. Any quick help is appreciated as this has an impact in the architecture.   Source: ADB - Tables Connectivit...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi AK92 ,

    I create a table as you mentioned.

    Then I create a new table and here is the DAX code.

    Table 2 = 
ADDCOLUMNS (
    FILTER (
        'Table',
        'Table'[sales] > 0
    ),
    "qcid", 'Table'[qc_id],
    "col1_1", 'Table'[col1],
    "col10_1", 'Table'[col10],
    "sales_1", 'Table'[sales],
    "SalesFlag", 1
)

    So when you use a slicer, it will give you what you want.

     

     

     

    Best Regards

    Yilong Zhou

    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 AK92 ,

I create a table as you mentioned.

Then I create a new table and here is the DAX code.

Table 2 = 
ADDCOLUMNS (
    FILTER (
        'Table',
        'Table'[sales] > 0
    ),
    "qcid", 'Table'[qc_id],
    "col1_1", 'Table'[col1],
    "col10_1", 'Table'[col10],
    "sales_1", 'Table'[sales],
    "SalesFlag", 1
)

So when you use a slicer, it will give you what you want.

 

 

 

Best Regards

Yilong Zhou

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