Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Below is table data in PowerBI (Desktop)
I want to create another table where data should be like
Being very new to BI, unable to generate the required output. Need help.
Regards
Solved! Go to Solution.
@Sam70 , In a table visual you can use a measure
countrows(Table)
Or can use count of any column
If you need calculated column, you can use Summarize
Summarize(Table, Table[Track], Table[ParameterA], Table[Account ID], Table[MonthName], Table[Customer Name], "Count", countrows(Table))
@Sam70 , In a table visual you can use a measure
countrows(Table)
Or can use count of any column
If you need calculated column, you can use Summarize
Summarize(Table, Table[Track], Table[ParameterA], Table[Account ID], Table[MonthName], Table[Customer Name], "Count", countrows(Table))
Hi @amitchandak ,
I made a mistake. Used your formula in a new table and it worked perfect.
Thank you
Regards