Forum Discussion

srlabhe's avatar
srlabhe
Super User
10 months ago
Solved

Implementing Snowflake SQL in PBI Import(NOT DQ as its not suggested)

Hi All, Actually I am trying to implement below query in Power BI Import(As dont wana use DQ with Dynamic parameter passed) SELECT Table1.*,'mapped', FROM Table1 WHERE as_of_date <= '2025-09-17'...
Need Help
  • v-dineshya's avatar
    v-dineshya
    10 months ago

    Hi srlabhe ,

    Thank you for the update. You want all latest dates(as_of_date) records for any Mapped ID/Unmapped ID. Please refer below output snap and attached PBIX file.

     

     

    In Slicer select on "2025-09-17", it will display the mapped records (latest date <= slicer date).

     

    EntityID       Dates <= 2025-09-17      Latest Date      Value
    A1                         09-10, 09-15               09-15            110
    A2                         09-12, 09-17               09-17            210


    In Slicer select on "2025-09-17", it will display the unmapped records (Earliest Date >= slicer date).

     

    EntityID             Dates >= 2025-09-17        Earliest Date    Value
    B1                           09-17, 09-19, 09-21       09-17              300
    B2                           09-18                             09-18              410

     

     

    I hope this information helps. Please do let us know if you have any further queries.

     

    Regards,

    Dinesh

     

v-dineshya's avatar
v-dineshya
Community Support
10 months ago

Hi  srlabhe ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

 

Regards,

Dinesh

v-dineshya's avatar
v-dineshya
Community Support
10 months ago

Hi  @srlabhe ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

 

Regards,

Dinesh