Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Change the amount of a value in a column if certain conditions are met

    Posted Dec 15, 2022 05:45 PM
    Edited by Kevin BP Dec 15, 2022 05:49 PM

    Hi,

     

    I would like for the value in my Count column to change from a 1 to a 0.5 but only if the person's name in my Scheduled Person column is the same 2 days in a row (back to back days) from my Appt date column. Also the Procedure needs to be equal to A and the Center needs to be equal B.



    ------------------------------
    Kevin BP
    Data Analyst
    ------------------------------


  • 2.  RE: Change the amount of a value in a column if certain conditions are met

    Bronze Contributor
    Posted Dec 16, 2022 11:04 AM
    Kevin, if you are working in PQ there is this incredibly helpful page I have bookmarked:

    https://gorilla.bi/power-query/replace-values/

    ------------------------------
    Amon Seagull
    McKinney
    ------------------------------



  • 3.  RE: Change the amount of a value in a column if certain conditions are met
    Best Answer

    Posted Dec 21, 2022 01:14 PM
    Solution can be found here:

    https://community.powerbi.com/t5/DAX-Commands-and-Tips/Change-the-amount-of-a-value-in-a-column-if-certain-conditions/m-p/2977857#M99748

    ------------------------------
    Kevin BP
    Data Analyst
    ------------------------------