Forum Discussion

RanHo's avatar
RanHo
Icon for Helper V rankHelper V
2 years ago

How to display specific data in table/matrix

Good day Guys! 
              I just want to know how can i display specific data . As you can see i have Sample User table, and then Sample Output I wanted to achieve.  For this project i just want to create column named ( RENEW ID NUMBER and RENEW TRANSACTION NUMBER ) which is the color green  column in output. Need to display the renew id and transaction for specific User/Name. 
        Any advice or help will acknowledge. Thank you in advance!

_RAN

Need Help
Show and Tell

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    2 years ago

    RanHo , Create an independent/disconnected date table and use that in slicer and try measure like

     

    //Date1 is independent Date table
    new measure =
    var _max = maxx(allselected(Date1),Date1[Date])
    var _min = minx(allselected(Date1),Date1[Date])
    return
    calculate( sum(Table[Value]), filter('Table', 'Table'[Entry Date] <=_max && 'Table'[Expiry Date] >=_max))

     

     

    Measure way
    Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM