Convert Calculated Column to Measure

abhiram342 — Wed, 31 Jan 2024 04:48:04 GMT

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

Re: Convert Calculated Column to Measure

Jihwan_Kim — Wed, 31 Jan 2024 04:56:21 GMT

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 ) )