Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Graph axis = two columns filtered

Hello,   I have a database with three columns: id, date created and end date. I need to make a graph by month/year and the value is the count of ids that its date created is before or equal to that...
Need Help
Tutorial Requests
  • VasTg's avatar
    VasTg
    6 years ago

    Anonymous 

     

    Hope you have a date dimension.

     

    The method i know is to create a new column in Date dimension as below.

     

    Column =
CALCULATE (
    COUNT ( 'Table'[id] ),
    FILTER (
        'Table',
        'Table'[date created] <= 'Table 2'[Date]
            && 'Table'[end date] >= 'Table 2'[Date]
    )
)

     

     

    Now use the month column in axis and (Max of New_column) as value in the graph.

    If this helps, mark it as a solution

    Kudos are nice too.

VasTg's avatar
VasTg
Memorable Member
6 years ago

Anonymous 

 

Hope you have a date dimension.

 

The method i know is to create a new column in Date dimension as below.

 

Column =
CALCULATE (
    COUNT ( 'Table'[id] ),
    FILTER (
        'Table',
        'Table'[date created] <= 'Table 2'[Date]
            && 'Table'[end date] >= 'Table 2'[Date]
    )
)

 

 

Now use the month column in axis and (Max of New_column) as value in the graph.

If this helps, mark it as a solution

Kudos are nice too.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you! That worked perfectly