Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Current Value - Previous Value

Im Trying to Achive Current value - Previous Value for a non Dates dataset , I have got the result using Offset function however when im trying to integrate the same measure into an existing measure im not able to get the correct result. 


I need help if there is any other way to achive current value - Previous value using dax measure 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous 

     

    Maybe you can try to use the EARLIER function, but this function only works for the calculated column.

     

    For details on its usage, you can refer to the following documentation:

    EARLIER function (DAX) - DAX | Microsoft Learn

     

    Here is an example:

     

    Sample:

     

    Create a calculated column as follows

     

    Column = CALCULATE(MAX('Table'[NAME]), FILTER('Table', [ID] < EARLIER('Table'[ID]) && [Category] = EARLIER('Table'[Category])))

     

     

    If I've misunderstood you, please provide detailed sample data and the results you are hoping for: How to provide sample data in the Power BI Forum - Microsoft Fabric Community . Or show it as a screenshot or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

     

    Best Regards,
    Community Support Team _Yuliax

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • Ahmedx's avatar
    Ahmedx
    Super User
    2 years ago

    could you share your pbix-file? Or create an example file which reproduces your issue?

  • SamInogic's avatar
    SamInogic
    Super User
    2 years ago

    Hi Anonymous ,

    Can you try below measure to get the difference?

    Previous Value =
    VAR CurrentValue = [YourCurrentMeasure]
    VAR PreviousValue = CALCULATE ( [YourCurrentMeasure], PREVIOUSMONTH ( 'Date'[Date] ) // Use 'Date' as per your dataset structure )

    RETURN CurrentValue - PreviousValue


    Thanks!

    Inogic Professional Services

    An expert technical extension for your techno-functional business needs

    Power Platform/Dynamics 365 CRM

    Drop and email at [email protected]

    Service:  http://www.inogic.com/services/ 

    Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous 

     

    Maybe you can try to use the EARLIER function, but this function only works for the calculated column.

     

    For details on its usage, you can refer to the following documentation:

    EARLIER function (DAX) - DAX | Microsoft Learn

     

    Here is an example:

     

    Sample:

     

    Create a calculated column as follows

     

    Column = CALCULATE(MAX('Table'[NAME]), FILTER('Table', [ID] < EARLIER('Table'[ID]) && [Category] = EARLIER('Table'[Category])))

     

     

    If I've misunderstood you, please provide detailed sample data and the results you are hoping for: How to provide sample data in the Power BI Forum - Microsoft Fabric Community . Or show it as a screenshot or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

     

    Best Regards,
    Community Support Team _Yuliax

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.