Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Referencing external tables column in function

Hi all, Hope you can help me with this. My basic question is, how can I reference an external table from within a function from within the PowerQuery editor. Here's my setup: I have a table w...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Create a date table and merge your holidays in that. And refer to working day formula in the given file between two dates and use that

https://www.dropbox.com/s/y47ah38sr157l7t/Order_delivery_date_diff.pbix?dl=0

 

In this file check how date has been to Order dim. Same way you can move holiday to date table and create 1,0 for working and  non working days

 

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks.
    I should have said this before I think, but I'm working in the PowerQuery editor here...
    I'll update the question in a sec.

    I guess this advice won't work there?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello amitchandak - Would you have additional insight into this topic, or would you advise me to raise this topic somewhere else?