How to transform a Power BI date column by range
Would someone give me a hand here? Still learning Power BI transformations. I have a column called created_at that has dates in format of ISO 8601 format YYYY-MM-DDTHH:MM:SSZ (Date/Time/TimeZone). I want to transform that column so that every value that is before 05/15/2022 is changed TO 05/15/2022 otherwise, leave the value the same. So the column should only have dates listed as 05/15/2022 or later.
DAX transform decimal to date
All, Here is my data, below. I'm looking to transform the decimal date ([Vacancy.Year Mo]) to a mm/dd/YYYY format ([Vac.Date]) with as little DAX effort as possible. And yes, I do need both columns for reasons in the report. Simply converting the column to date format throws an error. wah-wah-waaaah. Help me out with the DAX expression to do so? HUGE thanks in advance! Table: 'vac_history' column: [Vacancy.Year Mo] 2019.03 2019.09 2019.12 2019.06 2019.03 2019.09 2019.12 2019.06 column: [Vac.Date] = ('vac_history'[Vacancy.Year Mo]) 2019.03 2019.09 2019.12 2019.06 2019.03 2019.09 2019.12 2019.06 desired [Vac.Date] output after DAX transform: desired transformation 03/01/19 09/01/19 12/01/19 06/01/19 03/01/19 09/01/19 12/01/19 06/01/19
