If Else condition in Power BI

If Else condition in Power BI: -



   Open Your data set in Power BI desktop



2. Go to Query
Editor





3 . Go to Add
Column





4.Go to
Custom Column





5. Change your
header name

Output:

Total Number of Rows from a table in Power BI

Total Number of Rows in a Table: -



Go to Desktop mode on Power Bi
Go to Modelling
Go to New Column
Add this Formula
 Number_Of_Rows = COUNTROWS('Sales Data') – Your table_name.
   Enter


It will create a new column and will update the total number of rows from your table.