Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Need help with Dax/Logic on Calculated columns for same category and same day

Dear Powerbi Gods,   I have 2 databases. Customer_database and Visit_database. They are linked by Customer Name on 1 to many relationship.   Visit_Database Date of Visit Customer Name Sale...
Need Help
Show and Tell
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, Anonymous 

    Try  calculated columns as below:

    Current Day Sales Indicator = 
CALCULATE (
    MAX ( Visit_database[Sales Indicator] ),
    ALLEXCEPT (
        Visit_database,
        Visit_database[Date of Visit],
        Visit_database[Customer Name]
    )
)

    Weeknum = WEEKNUM(Visit_database[Date of Visit]) 
    Current week Sales Indicator = 
CALCULATE (
    MAX ( Visit_database[Sales Indicator] ),
    ALLEXCEPT (
        Visit_database,
        Visit_database[Weeknum],
        Visit_database[Customer Name]
    )
)

    Best Regards,
    Community Support Team _ Eason

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks alot!! This is exactly what I needed!!!😀😀