Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Column Variable


I have following variables:

VAR __exWDev=100
I want to add a new column named "filteredModels" to this variable. This should takes the values in tbl_GG[Model], those that meet the condition U_RST[TEST_DATE]<"some specific date"
tbl_GG[Model] is itself a calculated column, and the data model looks below pic:


I used ADDCOLUMNS, but I have two problems:
1. I cannot access contents of tbl_GG through ADDCOLUMNS formula. I tried also RELATED, but it didn't work. I suspect that something is wrong with my data modeling.
2. I cannot figuer out how to implement this condition: U_RST[TEST_DATE]<"some specific date" in ADDCOLUMN formula. 
I didn't go further than this piece of string: VAR __exWDev1=ADDCOLUMNS(__exWDev,"filteredModels",)
Any sort of help is appreciated. 
Frequent Visitor

@MFelix Thanks for the reply. 

Unfortunately I cannot share the data. I understand what you mean, but thanks for the offer.

To your points:

  1. The dates should be iterated. What I wrote as "some specific date", is actually successive weeks of year. Writing the for loop is the next challenge for me. But at the first step I am trying to formulate what I want for a single week namely "some specific date" and then try to loop the formula through different weeks.
  2. that’s exactly why I post my question with a photo of the data model. I am new to Power BI and have no clear idea about pros and cons of cardinalities and filter flows. I thought bidirectional filter flow gives me more flexibility to implement more variety of filtering as it sounds like: "bidirectional". And I am wondering how someone without knowing exactly what kind of analysis comes down the road, can decide the on filter flow at very beginning of data modeling. For me the bidirectional seemed less restrictive, that's why I set it so. Apart from that I don't understand from your first point if it’s the bidirectional filter flow that could make issued or 1-1 cardinality. 


Hi @madhas ,


The questions about the relationships and the flexibility are many especially because DAX is based on context.


Check this video about the 1-to-1 and their issues.


The question you place is relevant how you can decide without knowing the future but there are some best practices that allow to have the flexibility keeping flexibility.


Also check this links about the bidirectionality


Once again without any further information is difficult to give you a better help. If you want to reach out  please send a PM.


Miguel Félix

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português

Super User
Super User

Hi @madhas ,


WIthout data is difficul to pin point the problem, however I have a couple of questions:

  • You refer you want to have the calculation based on a specific date, is that date being hard coded or is it by a slicer or a filter on a visual?
  • I can see that you have a 1-to-1 with bidirectional filter this always brings issues because of the potential ambiguity. Why are you using this logic?

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.


Miguel Félix

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors