Forum Discussion

Figueiredo_Luis's avatar
Figueiredo_Luis
Frequent Visitor
3 years ago

Shortfall sales

Dear BI Comunity,

 

I am trying to create a DAX formula to return the shortfall sales using the sales target minus actual sale (MTD). The idea is to have it on a daily basis. I have created the formula below, however it returns the same result.
Sales Shortfall = SUMX(Dates,[MTD Sales]-[MTD Target])

Need Help

2 Replies

  • Figueiredo_Luis's avatar
    Figueiredo_Luis
    Frequent Visitor
    3 years ago

    Good day team - Actual i have sorted out with this issue. The formula above is correct however my MTD sales formula was not correct.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Figueiredo_Luis ,

    If I understand correctly, it seems that the return data is not correct when you use the above formula. What's your expected result? Could you please provide some raw data in your tables with Text format, the formula of [MTD Sales]&[MTD Target] and the Fields settings of your visual? It would be helpful to find out the solution. You can refer the following links to share the required info:

    How to provide sample data in the Power BI Forum

     

    And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

    How to upload PBI in Community

    Best Regards