Have a Measure that I need to convert to a calculated Column

[ss8551]

Hi, 

I have a Measure that works perfectly, however, I need to have this measure converted to a column so that I can add this to my Visualation.    Please note the Timeframe_1 is coming from a DirectQuery PBI.  All I really need is the if statement in the last two formulas to be a column so i can show post vs pre and/or calculate % of Post/Pre.

I currently have two columns:

Timeframe_1 = DATEDIFF('DirectQueryTable'[max_date],FIRSTDATE(Desktop_PBI[START_DT]),day)

Timeframe_2 = if([timeframe__1]>1,"Post-Training")
Timeframe_3 = if([timeframe__1]<=1,"Pre-training")

Would anyone know of a way to get the Timeframe measure into a calculated column so that i can add these to some visualtions?

When I attmept to put this data into a column the dateDiff changes and is no longer valid.

Any assistance is appreciated.

Thanks

[ryan_mayu]

could you pls provide the sample data and expected output?

[ss8551]

Certainly.  The data is correct in the Measure I just need to have the same data in a column so it can be added to the visual.

Below is the data including the two Measures I'm hoping to convert

		Measure	Measure
employee ID	start_date	Timeframe	DateDiff
ab123	4/1/2022	Pre-Training	-21
bc345	4/8/2022	Pre-Training	-14
de678	4/15/2022	Pre-Training	-7
fg901	4/21/2022	Pre-Training	-1
hi234	4/22/2022	Post-Training	3
jk567	4/25/2022	Post-Training	6

Below is what I'd like in a Calculated Column:

Calculated Column	Calculated Column
Timeframe	DateDiff
Pre-Training	-21
Pre-Training	-14
Pre-Training	-7
Pre-Training	-1
Post-Training	3
Post-Training	6

Thank you

[ryan_mayu]

could you pls provide the sample data? if we dont know your data structure, we can't create the calculated column

[ss8551]

I have a .pbix file that has the data, but while i have seen others upload thes to this site i don't see an option to do so.  when i try to drag and drop the attachement it doesn't allow .pbix files or .zip files.  please let me know how to upload this file to this site for you to be able to review.

Thanks

[ss8551]

Is there a way to add a power bi attachement?  I don't see the option availble here.  i can add a PBI that should show this but not sure how. I only see options for adding media, photo, video, HTML, and Emoji's I don't see how to attach a PBI file.  Sorry, I'm fairly new to this board.

Thanks

[ryan_mayu]

you can use onedrive to share, or you can just create some dummy data and paste in the reply.

[ss8551]

ryan_mayu,

thank you for all of your assistance.  I was able to get this to work with what you sent me.  I apprecaite all of your assistance.

[ss8551]

I've tried copy and paste of the pbi it didn't like it I had an error message I'll try again or try OneDrive

[ss8551]

https://att-my.sharepoint.com/:u:/r/personal/ss8551_att_com/Documents/Power%20BI%20Direct%20Query%20... 

[ryan_mayu]

i can't open the link

[ss8551]

https://onedrive.live.com/?cid=27ACF044218E0B2D&id=27ACF044218E0B2D%21119&parId=27ACF044218E0B2D%211... 

[ss8551]

please try the above file.  You should be able to open this file.  Sorry but it won't let me add a .PBIX file to this comment box.

[ss8551]

https://1drv.ms/u/s!Ai0LjiFE8Kwndw-pbUKhxXGMFFk?e=V8T0r5 

[ryan_mayu · Accepted solution]

@ss8551 

pls try this to create a column

Column = maxx(FILTER('Direct Query','Desktop PBI'[employee_ID]='Direct Query'[employee_ID]&&'Direct Query'[Course]=887744) ,'Direct Query'[comp_train])

[ss8551]

That was what I needed.  Thank you so much!

[ryan_mayu]

you are welcome