type-conversionpowerbibusiness-intelligencepowerbi-desktop
How to convert a specific text string to today's date in Power BI
I have a table with a column called that contains text. Most of the values are years. However, some have the value "present" to represent groups that are still currently active. I want to convert those values to today's year, and convert the column type to date (specifically year type). I want to avoid creating a new column if possible.
Solution
Please see below for the DAX language that worked.
= Table.ReplaceValue(#"Extracted Year2",null,DateTime.LocalNow() ,Replacer.ReplaceValue,{"Disbanded"})
- MongoDB, Convert a string with commas to double in $convert(aggregation). Failed to parse number '1,533.07'
- Convertion C to Golang with windows.h
- NUMBERS TO WORDS using html and javascript
- C++ pow unusual type conversion
- How to tweak std::stod (string to double) for decimal separator and number of digits
- Convert Array of objects to Hash with a field as the key
- Parsing bytes data in Python
- Error using TypeConverter (GSON) for Room with custom objects in Kotlin
- Pandas reading csv as string type
- Using generic trait methods like .into() when type inference is impossible
- C# Unable to cast object of type 'System.Double' to type 'System.Single'
- How to check that T or Any implements a trait in Rust lang
- How to convert Decimal to Double in C#?
- Why does c++ compiler want to convert to int when type isn't declared correctly?
- Creating a "view" of a sibling class avoiding unnecessary copy
- Python: convert string-pair to complex number
- ValueError: could not convert string to float: id
- How to cast a tensor to `complex` type in PyTorch?
- How to convert object to generic
- How do you change the datatype of a column in T-SQL Server?
- In Julia, how to convert a unsigned number to a signed number like in C?
- How to convert torch tensor to float?
- Torch - How to change tensor type?
- Convert u8 array to base64 string in Rust
- Does Rust have a way to convert several bytes to a number?
- convert string to number node.js
- Convert semicolon-separated string into table structure?
- String to date error (Conversion from string to type date is not valid)
- Can't convert string to int in PowerShell
- Typescript type for custom Record keys