Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

missing time series data part 3

Hi Experts   This is a follow on question from the link as shown: https://community.powerbi.com/t5/Desktop/Missing-data-in-time-series-part-2/m-p/682008#M328526   Firstly thanks for the excellent...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous ,

     

    Is my suggestion helpful to your scenario? If so, would you please accept it as an answer?

     

    Regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi Anonymous ,

 

I tested with below sample table.

 

New a calculated table, and change the date format to "MMMM yyyy"

result table =
ADDCOLUMNS (
    FILTER (
        CALENDAR ( MIN ( Sample1[Time] ), MAX ( Sample1[Time] ) ),
        DAY ( [Date] ) = 1
    ),
    "observations", CALCULATE (
        SUM ( Sample1[Observations] ),
        FILTER (
            Sample1,
            Sample1[Time].[Year] = YEAR ( EARLIER ( [Date] ) )
                && Sample1[Time].[MonthNo] = MONTH ( EARLIER ( [Date] ) )
        )
    ) + 0
)

 

Best regards,

Yuliana Gu

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Y GU....

    thanks for the excellent feedback. let me test. much appreicated.

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Microsoft Employee
      7 years ago

      Hi Anonymous ,

       

      Is my suggestion helpful to your scenario? If so, would you please accept it as an answer?

       

      Regards,

      Yuliana Gu