Forum Discussion

Amine008's avatar
Amine008
Frequent Visitor
4 years ago

DateDiff from same column with condition in Power BI

Hi All, I am having one table in PowerBI which is having 2 columns: 1.EnrollId 2.StatusChangeDate.  I want to find no. of days between two dates with status condition and excluding weekends. Saturday...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
4 years ago

Amine008 here is one video which I did on working dates, you can tweak and learn from here and implement in your solution. How to calculate shipping date based on the working date ignore non working days - Power BI - YouTube

 

 

 

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

 

 

Amine008's avatar
Amine008
Frequent Visitor
4 years ago

Thanks parry2k for reaching out. 
Would you please share sample of Pbix file used in this video ? 
I am having error while trying to duplicate the steps : Unexpected value for ORDER argument in RANKX function. Use 0/FALSE/DESC for descending order or 1/TRUE/ASC for ascending order.
Thanks
Amine