Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
FranckN
New Member

Add column that can be use in Row pivot table

Hello

 

I am simplify my example to help you to understand my question

So let say I have in my table 3 columns

  • Date
  • Hours
  • Amount

Example

DateHourAmount
23-May-2119:47:0850
24-May-2118:13:4430
27-May-219:04:5820
30-May-2111:14:2150

 

 

instead of having in my Pivot

  • Date in (rows)
  • and sum of amount in (Values.)

 

I add a colum in power pivot called shift like this

=if(hour>16:00,Date & "A", Date & B)

 

So my data is like this

DateHourAmountShift
23-May-2119:47:08505/23/2021B
24-May-2118:13:44305/24/2021B
27-May-219:04:58205/27/2021A
30-May-2111:14:21505/30/2021A

 

I would like to use in my pivot table

  • Shift in (rows)
  • and sum of amount in (Values.)

But I get error that I can move calculated field there.

 

What I can do? to be able to do it. what is the correct way.

 

thanks

1 ACCEPTED SOLUTION
FranckN
New Member

I found it

 

Just add a column and not Calculated column

thanks

View solution in original post

2 REPLIES 2
AlexisOlson
Super User
Super User

I'd expect this to work fine unless you accidentally defined a measure instead of a calculated column for Shift.

 

Can you share a screenshot of the error you're getting?

FranckN
New Member

I found it

 

Just add a column and not Calculated column

thanks

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.