topic Re: How to use DAX to link tables in DAX Commands and Tips

How to use DAX to link tables

sarahmclaughlin — Tue, 14 Jun 2022 12:35:49 GMT

Hi,

I'm a PowerBI novice, and I am trying to correct a database design error using DAX.

I have two client types (Survivor, Supporter), but only Survivor is linked to a table with the date the service was rendered (service_id). I need to count the number of Supporters per month, but PowerBI cannot see them because they are not linked to a date (through service_id).
I thought to create a custom column that can find the ClientPI_id that they both share, and then use the same (service_id) found for Survivor to populate the matching blank cell for Supporter. How could I achieve this with DAX? (Pic below)

I really appreciate some help!

Thanks, Sarah

Re: How to use DAX to link tables

DimaMD — Tue, 14 Jun 2022 13:55:10 GMT

Hi, sarahmclaughlin try it

Re: How to use DAX to link tables

sarahmclaughlin — Wed, 15 Jun 2022 06:13:41 GMT

Hi! I get a message saying it doesn't recognise MAXX, and documentation says "This function is not supported for use in DirectQuery mode" - https://docs.microsoft.com/en-us/dax/maxx-function-dax
Is there another function I could try? How did it work on your side? Thanks so much!!!

Re: How to use DAX to link tables

DimaMD — Wed, 15 Jun 2022 07:00:27 GMT

sarahmclaughlin You must create a computed column, not a measure, Please provide a screenshot of the error
See example
Example_pbix

Re: How to use DAX to link tables

sarahmclaughlin — Wed, 15 Jun 2022 07:06:08 GMT

Re: How to use DAX to link tables

DimaMD — Wed, 15 Jun 2022 07:52:54 GMT

sarahmclaughlin You do not need to do this in PowerQuery, but add a calculated column in PowerBi.

Re: How to use DAX to link tables

sarahmclaughlin — Wed, 15 Jun 2022 09:14:38 GMT

Thank you so much! This worked perfectly!!! I've been stuck on this for weeks!