Forum Discussion

JBI's avatar
JBI
Frequent Visitor
7 years ago

Difference between two points

Hi Guys,   I have data that is not transactional. Each entry is the current value for that month. Thus it's not data such as sales that can be summed but rather a single value at a point in time. ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

You could try something like 

CALCULATE(

                    SUM(

                             Sales[Monthly Sales]

                            )

                    )

-

CALCULATE(

                    SUM(

                             Sales[Monthly Sales]),

                    FILTER(

                               ALL('Calendar'), 

                               'Calendar'[Date]=Max('Calendar'[Date]) - 180

                               )

                   )

 

BR

JBI's avatar
JBI
Frequent Visitor
7 years ago

It's still returning the whole table. I want a scalar value returned. Surely there should be a simple way to do calculations like this in PowerBI

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi JBI ,

    Have you solved your problem?

    If you have solved, please  always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

    If you still need help, please feel free to ask.

    Best Regards,

    Cherry

     

    • JBI's avatar
      JBI
      Frequent Visitor
      7 years ago

      Hi,

      Did not get solution no. I got a solution on a different feed.

       

      Thanks

      • v-piga-msft's avatar
        v-piga-msft
        Resident Rockstar
        7 years ago

        Hi JBI ,

        If you get a solution, could you share and accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

        Best Regards,

        Cherry