Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
@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
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |