Create due date in power bi

DAX DAX Calculations
1

Hi everyone,

I am sure that there is an easy solution to my question and I am hoping that I can get some help here.

I am currently working on a WHS dashboard based on a direct query. The report contains an incident date and I would like to include a due date (5 days after the incident occurred). For example:

Incident Date Due Date

3-10-2021 8-10-2021

At the moment I querying an Excel spreadsheet to receive the due date information. However, I was hoping that there would an easier solution for that. Does anyone know how to solve this without an additional query?

Many thanks.

Julius

2

Hello @Julius,

Thank You for posting your query onto the Forum.

Well, this is achievable by writing a small simple measure. Below is the measure alongwith the screenshot of the final results provided for the reference -

Due Date = 
IF( ISINSCOPE( Data[Incident Date] ) , 
    SELECTEDVALUE( Data[Incident Date] ) + 5 , 
    BLANK() )

Final Results

I’m also attaching the working of the PBIX file for the reference purposes.

Hoping you find this useful and meets your requirements that you’ve been looking for. :slightly_smiling_face:

Thanks and Warm Regards,
Harsh

Due Date - Harsh.pbix (610.6 KB)

1 Like
3

Hi Harsh,

Thank you so much for your quick response.

The measure works perfectly when I put it into an empty table together with the incident date:

image

However, when I put it into the table with the other measures such as location etc. it doesn’t work properly:

image

Do you have any idea what causes this?

Thanks again.

Kind regards,

Julius

4

Hello @Julius,

Can you please provide the working or example PBIX file rather than providing screenshots?

It’s always difficult to provide solutions in a better and efficient without looking at the reference file and consumes the time of the members onto the Forum.

Thanks and Warm Regards,
Harsh

5

Hello Harsh,

Thanks for the quick response.

Unfortunately, I can’t because the file is based on Power BI data set containing sensitive information.

Thanks anyway. I will try to figure it out.

Julius

6

Hello @Julius,

If your data contains sensitive information and don’t want to compromise the “Confidential Integrity” then our expert have also created videos and resources where they’ve showcased about - “How to mask sensitive data”. Below are the links provided for your future references which will help you while posting the query onto the Forum.

Thanks and Warm Regards,
Harsh

https://forum.enterprisedna.co/t/tip-tools-and-techniques-for-providing-pbix-files-with-your-forum-questions/17763