Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello All,
I have a requiremet to show the count of old meter and new meter in a single matrix. Old meter count will be decreasing and new meter count will be increasing on daily basis. I am using direct query and not storing any data inside Power BI. Data from table itself coming as rolling total on daily basis (Sample data from the table provided below).
I wanted to display the min of old count and max of new count on monthly basis as shown below. Example for the month of october in matrxi, Count of old meter is 9000 and new meter is 2000. In november, Old meter is 5000 and new meter is 6000. Expected output is provided below.
I am facing challenges in creating a DAX measure to show the old and new count as metioned in matrix visual. I would appreciate any suggestions/input in showing the old and new count in a matrix.
Data from Input table
Date | Old Meter Count | New Meter Count |
10/20/2019 | 10000 | 1000 |
10/21/2019 | 9000 | 2000 |
11/5/2019 | 8500 | 2500 |
11/10/2019 | 7500 | 3500 |
11/12/2019 | 5000 | 6000 |
12/1/2019 | 4000 | 7000 |
12/15/2019 | 2000 | 9000 |
12/20/2019 | 1000 | 10000 |
Expected Output
Meters | Oct | Nov | Dec |
Old Meter Count | 9000 | 5000 | 1000 |
New Meter Count | 2000 | 6000 | 10000 |
Hi @manojsv19
try new table
NewTable = summarize('Table1';Table1[Date].[Month];"Old Meter Count";min('Table1'[Old Meter Count]);"New Meter Count";MAX('Table1'[New Meter Count]))
are sure you need output exactly as you showed above? it will not be so easy 🙂
do not hesitate to give a kudo to useful posts and mark solutions as solution
Hi,
Thank you for the inputs!!
Yes, my requirement is to show the output as provided in the example and am using direct query. I wanted to get the summarize count from the query and don't want to do the aggregration at Power BI.
Let me konw for any additional information.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
25 | |
17 | |
12 | |
12 | |
10 |
User | Count |
---|---|
33 | |
25 | |
16 | |
14 | |
13 |