Forum Discussion

srlabhe's avatar
srlabhe
Icon for Super User rankSuper 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

     

srlabhe's avatar
srlabhe
Icon for Super User rankSuper User
10 months ago

Thanks but its npt working as inteded as it should show all latest dates(as_of_date) records for any Mapped ID/Unmapped ID

v-dineshya's avatar
v-dineshya
Icon for Community Support rankCommunity Support
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
    Icon for Community Support rankCommunity 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
    Icon for Community Support rankCommunity 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