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 & Graduated are the two binary(0,1) value columns.

Need Help
Show and Tell
Tips and Tricks

3 Replies

  • 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