Column is INT. Corresponding column on Calender table is in Date format - way to showthat column?

[mmace1]

I have a measure:

calculate(min(FACTTimeSheet[FKProjTransDate]),TimeSheet[ApprovalStatus]="Posted")

but the column FKProjTransDate  is an INT, not a Date. So it will return something like 20220912; I'd like to get it formatted as a date. 

The Calendar table connects to FACTTimeSheet, and has a corresponding column for 2022-09-12 as a Date - is there a performant way to bring down the actual Date from the Calendar table, into this measure?  I think I've done this before long ago...

The reason I'm not just making an extra column in Date Format: 

• This is a live connection - so can't in power BI itself, and anyway I need it in the central model. 
• Live connection to a UAT AAS Cube, and while I can modify the Views to convert that INT to a Date, 90% chance that gets overwritten every night until we go live (or so I've experienced). So I'd rather solve this within the measure, which I can just save in an Excel file. 
  
  
  
  
  
  
  

[parry2k]

@mmace1 or try this measure:

calculate(min(DateTable[Date Column]),TimeSheet[ApprovalStatus]="Posted",FKProjTransDate)

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[Greg_Deckler]

@mmace1 Maybe:

Measure =
  VAR __Int = calculate(min(FACTTimeSheet[FKProjTransDate]),TimeSheet[ApprovalStatus]="Posted")
  VAR __Year = LEFT(__Int & "",4) + 0
  VAR __Day = RIGHT(__Int & "",2) + 0
  VAR __Month = MID(__Int & "",5,2) + 0
RETURN
  DATE(__Year, __Month, __Day)