cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FabioN
Frequent Visitor

Object table compute columns

Hello all,

I would like to create a table object, based on many tables from the model, and add some computed columns.

 

ProductIDAverageConsumptionConsumption1Consumption2NumberOfIssues   
        

 

Tables are:

PRODUCTS

ProductId

AverageConsumption

 

USAGE

Date

Productd

NumberUsed

 

I attach Usage twice, so I can have two columns for the same product and compare different date ranges.

Consumption1 and Consumption2 are the sum of NumberUsed for that ProductId on two different data ranges.

 

Up to now, it works.

I would like NumberOfIssue to be (as in Excel): IF(AND(Usage1>AverageUsage;Usage2>AverageUsage);2;1) to count the number of periods that are above the average usage (I know, the 1 is wrong, but it is just an example!).

 

Is it possible to perform such calculation in a table object? How can I reference dinamyc columns that are modifed with date ranges?

Should I go with the creation of a new measure, and then add that to the table object?

It's the first time I work on such calculation, so please just provide me basic info if this is feasable and if it is the correct approach.

 

Thank you very much!

 

Fabio

2 ACCEPTED SOLUTIONS
Icey
Community Support
Community Support

Hi @FabioN ,

 

It is suggested to create Measures. Calculated columns or calculated tables won't be changed dynamically by slicers or filters on report pages.

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

FabioN
Frequent Visitor

Hello, thanks to both your suggestions, and being a complete newbie to Power BI, I followed this Microsoft Training on DAX, that I suggest to everyone

https://docs.microsoft.com/it-it/power-bi/guided-learning/introductiontodax 

It is very easy to follow, and after that I was able to create all the measures I needed!

Thank you,

 

Fabio

View solution in original post

3 REPLIES 3
Icey
Community Support
Community Support

Hi @FabioN ,

 

It is suggested to create Measures. Calculated columns or calculated tables won't be changed dynamically by slicers or filters on report pages.

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

FabioN
Frequent Visitor

Hello, thanks to both your suggestions, and being a complete newbie to Power BI, I followed this Microsoft Training on DAX, that I suggest to everyone

https://docs.microsoft.com/it-it/power-bi/guided-learning/introductiontodax 

It is very easy to follow, and after that I was able to create all the measures I needed!

Thank you,

 

Fabio

View solution in original post

Greg_Deckler
Super User
Super User

Tough for me to follow. If you are creating a table in a DAX calculation and need it to be fully dynamic then use ADDCOLUMNS.

 

If you have created a DAX table in the data model you can add columns just like a normal table. 


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!