Need to display start date(min) and end date (max) for values

[Anonymous]

Hi all,

Need to dilplay start date(min) and end date (max) for a job.

job name              startdate          enddate

job 1                      date1               date1

job1                       date2               date2

job1                       date3                date3

job 2                      date1               date1

job2                       date2               date2

job2                      date3                date3

Output like

jOB         START DATE          ENDDATE

JOB1    MIN(STARTDATE)     MAX(ENDDATE)

JOB1    MIN(STARTDATE)     MAX(ENDDATE)

thanks in advance

Ravi

[Anonymous]

HI @Anonymous,

You can try to use these measure formulas to get the aggregated values based on current job category:

MinStart =
CALCULATE (
    MIN ( Table[StartDate] ),
    ALLSELECTED ( Table ),
    VALUES ( Table[JobName] )
)

MaxEnd=
CALCULATE (
    MAX ( Table[EndDate] ),
    ALLSELECTED ( Table ),
    VALUES ( Table[JobName] )
)

Regards,

Xiaoxin Sheng

[Anonymous]

Hi Team,

Thanks for the response!!!

I am able to get the Max and min date but i need to use those columns to Aixis(Line chart,gantt chart) bacause it is measure can we change it to column and i am using direct query to get the data

Please help me on this..

Regards,

Ravi

[Anonymous]

Hi @Anonymous,

Unfortunately, power bi has limited the Dax function usage in calculate column when you are work with direct query mode. Perhaps you can use t-sql query in advanced options to expand new columns with aggregate field results in your table.

Visualize data from Azure Data Explorer using a SQL query in Power BI 

Regards,

Xiaoxin Sheng

[amitchandak]

@Anonymous , you can get JOb1 and Job2, Create a Min or Max measure or In a table/matrix use firs/min and last/max as summarization.

[AlB]

Hi @Anonymous 

Just place the three fields in a table visual and take the min and max for startdate and enddate

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers