Power BI Report Builder DAX query

[patty789]

I have a paginated report that which i am using Power Bi Report Builder but i have many different columns that are lookups to other columns how can i apprach them on a expression. My datasource is Dataverse. 

[v-luwang-msft]

Hi @patty789 ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft]

Hi @patty789 ,

Refer the following article ,and check if it is helpful .

Write DAX queries in Report Builder #ssrs #dax #ssas #tabular

SQL Server Reporting Services Report Builder with DAX Query Support

Best Regards,

Lucien

[GilbertQ]

Hi @patty789 

You should be able to use the expression editor when creating the dataset to get the columns you need?

[patty789]

@GilbertQ  I am not sure how to achive that. 

[GilbertQ]

Hi @patty789 

That is the dataset settings once the dataset is created?

You would need to do this when you create the dataset?