Forum Discussion

Anonymous

Not applicable

9 years ago

Last Date with Filter DAX

Hello There, I am wondering if I should be using power BI to calculate my last date based on certain condition. For ex: I have a below table: Batch Name| Process Name| Status | last s...

Anonymous

Not applicable

9 years ago

Eric_Zhang Thanks again, but this isn't working.

It is reproducing my records in the table for multiple times. Repeated records are being displayed.

Microsoft Employee

9 years ago

Anonymous wrote:

Eric_Zhang Thanks again, but this isn't working.

It is reproducing my records in the table for multiple times. Repeated records are being displayed.

Anonymous

Could you share a pbix with sample file? You can upload it to any web storage and share the download link.

Anonymous
Not applicable
9 years ago
Eric_Zhang Apologies, I will not be able to share it as per my org policy. :(

I can explain the scenario here,

I have batch table which is my batch dim
I have process dim

Process Audit and Batch audit are my facts and I am trying to generate the report using these tables.

The report will look like:

Batch name | Batch start | Batch End | Batch status | process Name| process start | process end| process status| last successful run

One batch will have multiple processes running on different days and if the process fails, I need to show when was the last time this process run successfully.

I tried creating calculated column using below DAX as provided by you.

Last_date_col =
CALCULATE (
MAX ('process_audit_dup'[process_start]),
FILTER ('process_audit_dup', 'process_audit'[process_status] = "Completed" && RELATED([process_guid])= 'process_audit_dup'[process_guid])
)

What I did was, created a duplicate table with the same column and filter the duplicate table and then joining with original table to find the last date. But Still, this isn't working.