Relative Content

Tag Archive for powerbidax

DAX query doesn’t take into consideration working days

I need help in writing a DAX query which works out the difference between two dates(feedback receipt date and acknowledgement date) and minus any working days. e.g. if feedback date was the 12th and acknowledgement date was the 19th, the working days to acknowledge will be 5 days, minus Saturday and Sunday.

Row level security with multiple columns in Power BI

In order to be able to give access level to each user, I did the following.
I have a main database in which there are columns such as buyer and seller, transaction volume, transaction value,…
enter image description here