Forum Discussion

ChrisR22's avatar
ChrisR22
Helper III
2 years ago

Using a Table with Multiple Date Fields

Hello,   I have a table that has mutiple date fields: Project Table: requested completion date initiation date completion date delivery date along with several other columns relating to...
Need Help
Tips and Tricks
jeremic_nikola's avatar
jeremic_nikola
Frequent Visitor
2 years ago

Ok and how your report should look like?

When you choose dates, shoud the filter behave like OR condition between any of the dates?

 

What do you mean by universally?

ChrisR22's avatar
ChrisR22
Helper III
2 years ago

- could you clarify what you mean for this first question?

- i'm intending to have a slicer where I select any two dates and all charts will only represent data between those two dates. for example a chart showing volume of projects based on completion date over time would show only between dates A and B in the slicer, and an ajacent chart showing volumn of projects based on initiation date over time would also onnly show between dates A and B.

  • jeremic_nikola's avatar
    jeremic_nikola
    Frequent Visitor
    2 years ago

    Oh that - this is easy - just apply solution 1 (by specifying USERELATIONSHIP in measures) and you will get it:
    CHART 1 - This Measure: Volume of projects (BY DATE COMPLETED) = Calculate(COUNT(Projects[Id],USERELATIONSHIP(Calendar[Date],Projects[CompletedDate])
    CHART 2 - This Measure: Volume of projects (BY DATE INITIATED) = Calculate(COUNT(Projects[Id],USERELATIONSHIP(Calendar[Date],Projects[InitiatedDate])
    ....

    So, to summarize:

    1. Create INACTIVE Relationships between Calendar Date and each date column you want to do breakdowns

    2. Create MEASURES for each chart you want (by completed date, initiation date etc...)
    3. Put respective measures in respective charts

    4. Put ONE Slicer with Calendar Date
    5. Enjoy....