Forum Discussion

rintu's avatar
rintu
Regular Visitor
3 years ago

Tableau to PowerBi conversion

Hi,   I am working on a report conversion from Tableau to PowerBI.  SUM(max([Inclass],[Graduated])) is the calculation used in Tableau. Can anybody help with the same logic in PowerBI? Inclass & ...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi rintu ,

You can follow the steps below to get it:

1. Create a calculated column as below to get the max value between the field [Inclass] and [Graduated]

 

Column = 
IF (
    'Table'[Inclass] > 'Table'[Graduated],
    'Table'[Inclass],
    'Table'[Graduated]
)

 

2. Create a card visual and apply the new calculated column on it with the aggregation SUM

Best Regards

rintu's avatar
rintu
Regular Visitor
3 years ago

Hi,

 

Thanks for the solution. But the tableau formula is as follows: SUM(max([Inclass],[Graduated])) / LOOKUP(SUM([Inclass]), FIRST()) ; which needs to be converted to PowerBI.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi rintu ,

    Could you please provide some raw data in your table (exclude sensitive data) with Text format and your expected result with backend logic and special examples base on the sample data? It would be helpful to find out the solution. You can refer the following links to share the required info:

    How to provide sample data in the Power BI Forum

     

    And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

    How to upload PBI in Community

    Best Regards