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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.