Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hi Team,
I have 3 fields Team,Name,Amount , need to calculate amount based on team and overall as showed in result1 result2 column
Thanks
Jen
Solved! Go to Solution.
@jenani_user Maybe:
result1 measure =
VAR __team = MAX('Table'[team])
VAR __table = FILTER(ALL('Table'),[team] = __team)
VAR __result = SUMX(__table,[amount])
RETURN
__result
result2 measure = SUMX(ALL('Table'),[amount])
@jenani_user Maybe:
result1 measure =
VAR __team = MAX('Table'[team])
VAR __table = FILTER(ALL('Table'),[team] = __team)
VAR __result = SUMX(__table,[amount])
RETURN
__result
result2 measure = SUMX(ALL('Table'),[amount])
Thank you so much!!!!
Similarly I need to calculate amount for the month i.e MTD
Can you help with this @Greg_Deckler ?
Thanks
Jen
@jenani_user I don't see dates anywhere, but here is some of the basics of date intelligence.
You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000
Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
Hi Team,
I have 4 fields Team,Name,Amount ,Date, need to calculate amount based on team and overall as showed in result1MTD, result2MTD column based on date selection
Thanks
Jan
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
18 | |
13 | |
7 | |
7 | |
5 |