Convert Calculated Column to Measure

[abhiram342]

Hi All - I have table with Pipeline Information and want to convert calculated column into measure. Please Provide your suggestions.

Table:PipelineRuns : this table contains pipeline information and duration for each run based on start and finishdate.

Measure: Calculate PipelineDurationCalculated column to measure.

Currenlty, I'm able to achieve using calcuated Column but I want to connvert it into measure

Example:

PipelineDurationCalculated = DATEDIFF(PipelineRuns[StartDate], 'PipelineRuns'[FinishedDate], DAY)

MaxPipelineDuration = MAX('PipelineRuns'[PipelineDurationCalculated])

Expected Ouput:

Thanks,

Abhiram

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic model looks like, but please check the below picture and the attached pbix file if it suits your requirement.

MaxPipelineDuration Measure: =
MAXX (
    PipelineRuns,
    DATEDIFF ( PipelineRuns[StartDate], 'PipelineRuns'[FinishedDate], DAY )
)