Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
141 | |
107 | |
100 | |
82 | |
74 |