Forum Discussion

abhiram342's avatar
abhiram342
Microsoft Employee
2 years ago
Solved

Convert Calculated Column to Measure

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
"DAX help"
DAX Measures
  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

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

1 Reply

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    2 years ago

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