Forum Discussion

totamum's avatar
totamum
Icon for Helper I rankHelper I
1 year ago
Solved

Create Card Showing Latest Value

I'm trying to create a Card which will display the latest Week on Week percentage that I have calculated.  My table is below.  The columns are measures based on other data.  I would like to show the ...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    1 year ago

    Hi, 
    I am not 100% sure how your semantic model looks like, but I tried to create a sample pbix file like below.

    Please check the below picture and the attached pbix file.

     

     

     

    users: = 
SUM( users[users] )

     

    OFFSET function (DAX) - DAX | Microsoft Learn

     

    Previous week users: = 
IF (
    NOT ISBLANK ( [users:] ),
    CALCULATE (
        [users:],
        OFFSET ( -1, ALL ( period[week] ), ORDERBY ( period[week], ASC ) )
    )
)

     

    WoW %: = 
DIVIDE([users:]-[Previous week users:], [Previous week users:])

     

    Latest WoW%: = 
VAR _t =
    FILTER (
        ADDCOLUMNS ( ALL ( period[week] ), "@wow%", [WoW %:] ),
        [@wow%] <> BLANK ()
    )
VAR _latestweeknumber =
    MAXX ( _t, period[week] )
RETURN
    CALCULATE ( [WoW %:], KEEPFILTERS ( period[week] = _latestweeknumber ) )

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Your solution is so great Jihwan_Kim and POSPOS , It's worked !

Hi, totamum 

I wish you all the best. Previously, Super user Jihwan_Kim and POSPOS provided a solution to help you solve the problem. Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
If you've already resolved the issue, you can mark the helpful reply as a "solution" so others know that the question has been answered and help other people in the community. Thank you again for your cooperation!
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.

 

Best Regards

Jianpeng Li