Dax Help Needed Comparison of Results

[kballar1]

 

I have a physical date column and a workflow status column that has several different statuses such as "waiting on approval" etc. 

I need to compare the physical date with the workflow status "Received Pricing" in order to find out how many days are between the two. 

Basically how many days it took to reach the workflow status of "received pricing". Wanting to know how long it took to reach that approval status. 

[Anonymous]

Hi @kballar1 

For your question about calculating the date interval, here is the method I provided:

Here's some dummy data

Create a measure, query the start date, end date of the workflow, and calculate the date interval.

Date intervals = var start_date = CALCULATE(MAX('Table'[Physical Date]), FILTER(ALL('Table'), 'Table'[Product ID] = MAX('Table'[Product ID]) && 'Table'[Workflow Status] = "-waiting on approval"))

var end_date = CALCULATE(MAX('Table'[Physical Date]), FILTER(ALL('Table'), 'Table'[Product ID] = MAX('Table'[Product ID]) && 'Table'[Workflow Status] = "-Received Pricing"))

RETURN DATEDIFF(start_date, end_date, DAY)

Here is the result.

If you're still having problems, provide some dummy data and the desired outcome. It is best presented in the form of a table.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy]

@kballar1 

Can you share some sample data with the desired output to have a clear understanding of your question?
Mention whether you want a calculated column or measure.
You can either paste your data in the reply box or save it in OneDrive, Google Drive, or any other cloud-sharing platform and share the link here.

[kballar1]

 

I have to create the difference between the physical date and the created on date, using the the "received pricing" status in the workflow status. 

I am needing to know how many days it took to get to that specific status("Received pricing" in the workflow status columns-which has multiple different status types). 

so basically how many days between physical date to created date with the filter "received pricing" in the workflow status column. 

[Fowmy]

@kballar1 

Without sharing all the columns that are involved in the logic, it's won't possible to come out with a working solution. 

Sharing a dummy Power BI file representing your scenario would be beneficial. You can save the Power BI file on Google Drive or any other cloud storage platform and provide the link here. Kindly ensure that permission is granted to open the file.

[Anonymous · Accepted solution]

Hi @kballar1 

For your question, try the following：

Here's some dummy data

“Table”

Create a measure

Measure = 
    var physical_date = 
        SELECTEDVALUE(
            'Table'[Physical Date]
        )
    var createdon_date = 
        SELECTEDVALUE(
            'Table'[Createdon.date]
        )
RETURN 
    IF(
        SELECTEDVALUE('Table'[Workflow Status]) = "-Received Pricing", 
        DATEDIFF(physical_date, createdon_date, DAY), 
        BLANK()
    )

Here is the result

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[kballar1]

I am looking at creating a measure. Wanting to know how many days occurred between the start date and the "received pricing" status in the workflow status column