Creating a similar calculation to a Level of Detail Calcualtion in Tableau

[tstackhouse]

I have the following Level of Detail (LoD) calculation from one of my Tableau workbooks. I am hoping to get some insight on how I would go about replicating this calculated field in power BI.

[v-yulgu-msft]

Hi @tstackhouse,

As I am not familiar with the Level of Detail (LoD) calculation you provided, please post sample data and share us your desired output so that I can try to achieve the same requirement in Power BI.

Regards,
Yuliana Gu

[tstackhouse]

Hello @v-yulgu-msft,

Attached is essentially what I would like to see. Included is  the Patients (by their DoB) that have purchased an "O/B/MR" item.

 "O/B/MR" is a calculated field which says:

if [drugname] contains "name of certain drug" then "O" elseif [drugname] contains "name of certain drug" then "MR" elseif [drugname] contains "name of certain drug" then "B" END

I am not that familiar with Power BI so I am not sure how to post sample data but below is hwat the end result looks like on Tableau. With Taableau you can attached a packaged workbook to the forums, I am not sure that there is a way to do this with Power BI.

Thank you!

[v-yulgu-msft]

Hi @tstackhouse,

O/B/MR =
IF (
    NOT ( ISERROR ( FIND ( "O", Table1[Drug Name], 1 ) ) ),
    "0",
    IF (
        NOT ( ISERROR ( FIND ( "B", Table1[Drug Name], 1 ) ) ),
        "B",
        IF ( NOT ( ISERROR ( FIND ( "MR", Table1[Drug Name], 1 ) ) ), "MR", BLANK () )
    )
)

Replace 'Table1' with your own table name. And replace the text highlighted in red with the actual "name of certain drug".

Best regards,
Yuliana Gu

[TomMartens]

Hey,

basically it's no problem to re-create the Level Of Details calculations from Tableau in Power BI. This is done by using the DAX query language.

Here is a little example

https://community.powerbi.com/t5/Desktop/Level-of-Detail-Calcs/td-p/17839

If you need further assistance, it would be helpfuls, if you can share some sample data, by providing a link to an Excel file on onedrive or dropbox.

Hope this gets you started

Regards

Tom