Forum Discussion

OskariNi's avatar
OskariNi
Helper I
8 years ago

Create column filled with measures

I have multiple measures (six in total, representing quarters of a year Q1,Q2,etc) that are counts from a column. I would like to create a new column with these six values and add the the column to a...
Need Help
prateekraina's avatar
prateekraina
Memorable Member
8 years ago

Hi OskariNi,

 

Here is how you can do it in Power BI:

 

1. Pull in your columns required for the measure calculation and other columns if you need to showcase them in the table.

2. When the data is loaded in Power BI, right click on your table and Create Measure. Use the same DAX to create your 3 measures which you used in Excel.

3. When all the measures are created, Drag a table visual on the canvas.

4. Drag all the 5 columns which you showcased in the screenshot.

5. Now start dragging your 3 measures, you will see the exact same table as it was in Excel.

 

Let me know if you face any issues.

 

Prateek Raina

OskariNi's avatar
OskariNi
Helper I
8 years ago

Hi prateekraina, 

 

Thank's for the reply. The thing is that I don't really want to see the table on the canvas. I wan't to have the table as data in the FIELDS part and then use it to draw a bar chart like this: 

 

Thanks, Oskari