Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Advice on how to structure data for variable requirements?

Hey everyone, I'm hoping I can get some advice from you more seasoned data analysts/Power BI experts out there. I have a simple outcome I'm aiming for but I'm not sure how best to lay everything out...
Need Help
Tutorial Requests
nhoward's avatar
nhoward
Icon for Resolver I rankResolver I
6 years ago

HI Anonymous 

 

First thoughts...  PBI works best with non-normalised tables.  So keep adding columns for the conditions, rather than thinking of groups of rows as conditions. 

eg

 

Certification | Course     | Level | Required | Alternative | Optional

PBI Cert       | Measures  | 1       | Yes          |  No             | No

PBI Cert       | Overview  |  1      |  No          | Yes             | Yes

PBI Cert       | Reviewing | 2      |  No          |  Yes            |  Yes

PBI Cert       | Strucuture | 2     |  No           | Yes            | Yes

 

Then you might be able to use DAX to find out someone who is qualified, by joing the results table.  If some one completed the Required from level 1 OR an Alternative from Level 2.