Forum Discussion

vincenardo's avatar
vincenardo
Helper I
4 years ago
Solved

Create line chart that counts dates from two columns in data set and displays count by date

In my data set, I have two columns with dates. DteOnHold & DteOffHold   I want to create a line chart that counts the the number of dates for each column (DteOnHold & DateOffHold) by day. I ...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, vincenardo ;

    You could create two measures as follows:

    count of DteOnHold = CALCULATE(COUNT([DteOnHold]),FILTER(ALL('Table'),[DteOnHold]=MAX('Calendar Relative'[Date])))
    count of DteOnHold = CALCULATE(COUNT([DteOnHold]),FILTER(ALL('Table'),[DteOnHold]=MAX('Calendar Relative'[Date])))

    In addition , two tables don't have relationship.

    The final output is shown below:

    If not right ,can you share the output and more details  you want to achieve?


    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, vincenardo ;

You could create two measures as follows:

count of DteOnHold = CALCULATE(COUNT([DteOnHold]),FILTER(ALL('Table'),[DteOnHold]=MAX('Calendar Relative'[Date])))
count of DteOnHold = CALCULATE(COUNT([DteOnHold]),FILTER(ALL('Table'),[DteOnHold]=MAX('Calendar Relative'[Date])))

In addition , two tables don't have relationship.

The final output is shown below:

If not right ,can you share the output and more details  you want to achieve?


Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

vincenardo's avatar
vincenardo
Helper I
4 years ago

This works perfectly! Thanks!