Forum Discussion

Miguelcrz's avatar
Miguelcrz
Helper I
6 years ago

WEEK VARIATION

Hello,   I need to have the variation % of my sales comparing it vs the last week like this:       My power BI currently looks like this:   And my table of time looks like this (S...
Need Help
FrankAT's avatar
FrankAT
Community Champion
6 years ago

Hi Miguelcrz 

here is another solution to your question. Use the three measures below.

 

 

Regards FrankAT

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Miguelcrz,

    You told us these codes not works without any detailed information, they not help to resolve your scenario and hard to clarify/troubleshoot the issues.
    Can you please provide a pbix file with dummy data and formulas to test? I think it should help for testing the coding formula on your sample data. (remove sensitive data before share)

    How to Get Your Question Answered Quickly 

    Regards,

    Xiaoxin Sheng