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.
Hi all,
May i know,
* what should i do if i want to know how many in total for "Number 1", "Number 2" until "Number 9999" ?
can i do it in query editor before apply?
* what should i do if i want to know how many "Number 1" appeared in Jan, Feb, Mar, until Dec?
can i do it in query editor before apply?
Appreciate for help!
Thanks
Regards
sean
Hi Sean,
Did you fail to do it with DAX? These two question is simple to handle with DAX. How much memory do you have?
Q1. Drag the column "Num" to the fields of a table visual twice. Set the first one to "Don't summarize" and set the second to "Sum".
Q2.
1) Create an independent date table.
DateTable = CALENDAR ( DATE ( 2017, 1, 1 ), DATE ( 2017, 12, 31 ) )
2) Establish relationship between DateTable[Date] and YourTable[Date].
3) Drag the DateTable[Date] and YourTable[Num] to the fields of a table visual.
4) Set date to hierarchy of Year-Month and set [num] to count.
5) Filter out "Number 1".
Best Regards!
Dale
hi victor,
i tried. evaluate out of memory. sad.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |