Print Document

PowerBi Reference Document
Version 01
Release Date 01 Jan 2021
Type SAP Documents
Status Released

Add Serial No / Index column to Model

1. Click on Transform Data

 

2. Select Index column on AddColumn Tab to generate Index.

 

Measure : Count Distinct with Filter

 

How to Concatenate Date and Time field to One field using transform function

1. Transform --> Change Date Column to Date Type

 

2. Transform : Convert the Date column back to text column. (Note : This transformation should be inserted as a new step)

 

4. Transform : Convert Time column to Type Time 

5. Transform : Convert Time Column form Type Time to Text.

The ultimate aim to have a text column of Date and Time properly converted.

6. Create a new Column and use the following to Concatenate Date and TimeField

.

 

7. Convert the new column to Date/Time Type.

 

Alternatively , point 6 -7 can be achieved using standard  date parsing functionality. Select the Date and Time column and use Combine Date/Time option.

 

IF ELSE condition in DAX.

In standard Power Bi / Power Query there is an option for creating conditions column without the need to add any code. But the limitation is AND / OR conditions cannot be added. For such requirements the statement in entered manually.

 

 

Sample Code

 

 

 


Table of contents

Technical Documents
Configuration Guide
External Reference
SAP Note
SDN Links
Messages
Sample Code