Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hello
Please see below We need 4 as an output as oracle output has 4 rows of output Request you to please find below dummy data
Thank you so much for help
Data
Orderno OrderLineNumber Shippeddate ScheduleDate
1232 4 14-11-2022 20211113
2323 6 16-11-2022 20221115
2323 5 16-11-2022 20221115
2323 7 16-11-2022 20221115
2323 8 16-11-2022 20221115
6556 6 24-11-2022 20211113
4543 7 23-11-2022 20221115
4543 8 23-11-2022 20221115
Query in oracle
SELECT COUNT(ORDERNO) CNT,
SCHEDULEDATE,
ShippedDate
FROM TABLE1
GROUP BY ORDERNO,
SCHEDULEDATE,
ShippedDate
Output In Oracle
Cnt ScheduleDate Shippeddate
1 14-11-2022 20211113
4 16-11-2022 20221115
1 24-11-2022 20211113
2 23-11-2022 20221115
Power Bi Output
4 4 Should be output as above Oracle output has 4 rows
Solved! Go to Solution.
Hi, @gshaikh
You can new a summarized table and then count the rows of this summarized table:
Result2 =
var tab=SUMMARIZE (
'Table',
'Table'[Orderno],
'Table'[ScheduleDate],
'Table'[Shippeddate],
"Cnt", COUNT ( 'Table'[Orderno] )
)
return COUNTROWS(tab)
Best Regards,
Community Support Team _ Eason
Thank you so much for help its work for me Thanks again
Hi, @gshaikh
You can new a summarized table and then count the rows of this summarized table:
Result2 =
var tab=SUMMARIZE (
'Table',
'Table'[Orderno],
'Table'[ScheduleDate],
'Table'[Shippeddate],
"Cnt", COUNT ( 'Table'[Orderno] )
)
return COUNTROWS(tab)
Best Regards,
Community Support Team _ Eason
User | Count |
---|---|
84 | |
76 | |
75 | |
43 | |
36 |
User | Count |
---|---|
109 | |
56 | |
52 | |
48 | |
43 |