Forum Discussion

mike_true80's avatar
mike_true80
Regular Visitor
9 years ago
Solved

Plotting multiple date values on a reference axis

I work with datasets that have multiple date/time values per row for task and activity type tracking.   I'm trying to vizualize the data against a reference axis rather than having to chose just on...
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi mike_true80,

     

    To calculate the count value of Start and End per month, you can create below measure:

     

    StartPerMonth = CALCULATE(COUNTA('Table1'[Start]),FILTER(ALL(Table1), MONTH(Table1[Start])=MAX('calendar'[Month])))

     

    EndPerMonth = CALCULATE(COUNTA('Table1'[End]),FILTER(ALL(Table1), MONTH(Table1[End])=MAX('calendar'[Month])))

     

    To plot a line chart to display count value of Start and End for each day, the measures should be below:

     

    StartPerDay = CALCULATE(COUNTA(Table1[Start]),FILTER(ALL('Table1'),'Table1'[Start]<=MAX('calendar'[Date])))

     

    EndPerDay = CALCULATE(COUNTA(Table1[Start]),ISBLANK('Table1'[End])=FALSE(),FILTER(ALL('Table1'),'Table1'[End]<=MAX('calendar'[Date])))

     

    Please check attached .pbix file.

     

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi mike_true80,

 

To calculate the count value of Start and End per month, you can create below measure:

 

StartPerMonth = CALCULATE(COUNTA('Table1'[Start]),FILTER(ALL(Table1), MONTH(Table1[Start])=MAX('calendar'[Month])))

 

EndPerMonth = CALCULATE(COUNTA('Table1'[End]),FILTER(ALL(Table1), MONTH(Table1[End])=MAX('calendar'[Month])))

 

To plot a line chart to display count value of Start and End for each day, the measures should be below:

 

StartPerDay = CALCULATE(COUNTA(Table1[Start]),FILTER(ALL('Table1'),'Table1'[Start]<=MAX('calendar'[Date])))

 

EndPerDay = CALCULATE(COUNTA(Table1[Start]),ISBLANK('Table1'[End])=FALSE(),FILTER(ALL('Table1'),'Table1'[End]<=MAX('calendar'[Date])))

 

Please check attached .pbix file.

 

 

Best Regards,
Qiuyun Yu