Forum Discussion

kdsan's avatar
kdsan
Regular Visitor
8 years ago
Solved

Count based on change in year

Good morning.    PowerBI newbie here.  I have used power query before and, to a (much) lesser extent, power pivot.  Doing this for a class project but I'd also like to be able to leverage this for ...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    kdsan

     

    Try this calculated column

     

    Repeat same YEAR =
VAR mycount =
    CALCULATE (
        COUNTROWS ( Donation_Level ),
        ALLEXCEPT ( Donation_Level, Donation_Level[ID], Donation_Level[Year] )
    )
RETURN
    IF ( mycount > 1, "Y", "N" )
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

kdsan

 

Try this calculated column

 

Repeat same YEAR =
VAR mycount =
    CALCULATE (
        COUNTROWS ( Donation_Level ),
        ALLEXCEPT ( Donation_Level, Donation_Level[ID], Donation_Level[Year] )
    )
RETURN
    IF ( mycount > 1, "Y", "N" )
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

kdsan

 

And this one

 

Repeat Multiple Years =
VAR mycount =
    CALCULATE (
        DISTINCTCOUNT ( Donation_Level[Year] ),
        ALLEXCEPT ( Donation_Level, Donation_Level[ID] )
    )
RETURN
    IF ( mycount > 1, "Y", "N" )
    • kdsan's avatar
      kdsan
      Regular Visitor
      8 years ago
      Perfect! Thank you so much!