Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
I have a situation where I need to calculate data and save it in different table for reporting
Raw data
I want result in below format
Solved! Go to Solution.
@PBX_user , Create a new table using DAX go to modelling and create new table and use Summarize
SecondTable =
SUMMARIZE(
'FirstTable',
'FirstTable'[Month],
'FirstTable'[State],
"No of Tasks", COUNTROWS('FirstTable')
)
Proud to be a Super User! |
|
@PBX_user , Create a new table using DAX go to modelling and create new table and use Summarize
SecondTable =
SUMMARIZE(
'FirstTable',
'FirstTable'[Month],
'FirstTable'[State],
"No of Tasks", COUNTROWS('FirstTable')
)
Proud to be a Super User! |
|
Thank you bhanu_gautam that worked.
I have different set of data as well, how I can create a result set of this data set
raw data:
Result needed as below:
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
19 | |
14 | |
10 | |
9 | |
9 |
User | Count |
---|---|
15 | |
12 | |
12 | |
11 | |
11 |