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 IV
Super User IV

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!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Kudoed Authors