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.
I need Any one help on this Dax query
Amount = CALCULATE(SUM(Demo[total]), MONTH(Demo[startdate]) >=MONTH(TODAY()),MONTH(TODAY()) <=MONTH(Demo[enddate]))
this dax query returns the total of all categories
Amount = 100
but i want to display catgories wise with that measures.. for example,
Books 20
Benches 30
pens 10
bags 40
i tried to groupby that dax queries that not works... Kindly let me know if any solutions is possible..
Advance thanks to all,
Solved! Go to Solution.
@Anonymous , Are you running this query in dax studio ?
If you doing that is power bi, then you need axis/row/field to group data on the visual
@Anonymous - Yes, but it is difficult to provide an exact solution as I do not understand your source data or what exactly you are trying to accomplish. The general format is:
Measure =
VAR __Table =
GROUPBY(
'Table',
[Grouping Column],
"Aggregation",SUMX(CURRENTGROUP(),[Value Column])
)
RETURN
<some operation over __Table>
If that is not specific enough, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
@Anonymous , Are you running this query in dax studio ?
If you doing that is power bi, then you need axis/row/field to group data on the visual
hi @Greg_Deckler ,
Thanks for your reply, but I need to group by that in measure ...not using the visuals is it possible?
@Anonymous - Yes, but it is difficult to provide an exact solution as I do not understand your source data or what exactly you are trying to accomplish. The general format is:
Measure =
VAR __Table =
GROUPBY(
'Table',
[Grouping Column],
"Aggregation",SUMX(CURRENTGROUP(),[Value Column])
)
RETURN
<some operation over __Table>
If that is not specific enough, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |