Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
86 | |
80 | |
69 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |