Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Getting wrong project dates when generating table...

Hello PBI community:   I'm tracking revenue for projects over a few months; some projects generate revenue, and others stop (i.e., not cumulative total).    I have a table that has one row for ea...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous

     

    Please check if below table matches your request.

    Table = 
FILTER (
    GENERATE (
        SELECTCOLUMNS ( 'My Date Table', "My Date", 'My Date Table'[Date] ),
        Projects
    ),
    Projects[Est Start Date] <= [My Date]
        && Projects[Est End Date] >= [My Date]
        && DAY ( [My Date] ) = 1
)

    Regards,

    Cherie

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous

 

Please check if below table matches your request.

Table = 
FILTER (
    GENERATE (
        SELECTCOLUMNS ( 'My Date Table', "My Date", 'My Date Table'[Date] ),
        Projects
    ),
    Projects[Est Start Date] <= [My Date]
        && Projects[Est End Date] >= [My Date]
        && DAY ( [My Date] ) = 1
)

Regards,

Cherie