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