Forum Discussion

shelbsassy's avatar
shelbsassy
Icon for Resolver I rankResolver I
9 years ago
Solved

Eliminating null or duplicate rows in a table calculated from summarize function

I created a table to get the distinct irst date of the month and the Max Service Date (from the data load) from  TrendCalcs = SUMMARIZE(Dates,Dates[FirstDateC],Dates[MaxPerMonth]) and I added a colu...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    Hi shelbsassy

     

    You could try something like this?

     

    TrendCalcs = SUMMARIZE(
        FILTER(
            Dates,
            'Dates'[FirstDateC]<> BLANK()
            ),
            'Dates'[FirstDateC],
            Dates[MaxPerMonth]
            )
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi shelbsassy

 

You could try something like this?

 

TrendCalcs = SUMMARIZE(
        FILTER(
            Dates,
            'Dates'[FirstDateC]<> BLANK()
            ),
            'Dates'[FirstDateC],
            Dates[MaxPerMonth]
            )
shelbsassy's avatar
shelbsassy
Icon for Resolver I rankResolver I
9 years ago

OMG Worked beautifully the first try!  Thank you so much!