Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

New column with dates after 1/9/2021

I am trying to create a new column that will just show me data from a date column if the date is greater than 1/9/2021. Please can you help me. Many thanks
  • jaipal's avatar
    jaipal
    4 years ago

    Anonymous  in the power query, right click on date column and click on Date Filters-->After

    you can manage the data by giving the Date

TheoC's avatar
TheoC
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous 

 

Add this part as its own measure: CALCULATE(SUM('Detentions (2)'[Payback]),ALLEXCEPT('Detentions (2)','Detentions (2)'[Adno]))+0 

 

Then just add the measure as the "else" in your if statement.

 

Hope that makes sense.

 

Theo

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Sorry im not sure where to put the ELSE, I have both of these collumns working ok on their own, but i want them to work together in one collumn?
Collumn name = If ('Detentions (2)'[after sept]>date(2021,09,01),'Detentions (2)'[Detention Date]) ELSE, CALCULATE(SUM('Detentions (2)'[Payback]),ALLEXCEPT('Detentions (2)','Detentions (2)'[Adno]))+0