I want a DAX formula that is concatenating a month number to a year.
If the month number is less than 10, I want to add a leading zero to it but I'm new to DAX and I can't seem to figure out how to do it?
You can use the FORMAT function for this:
Expiry_MonthYear_Sorter = FORMAT([Expiry_Date], "YYYYMM")
1. Go to Modelling ribbon -> Manage ...READ MORE
Follow the below steps:
Create a column with ...READ MORE
To create a custom column, we need to ...READ MORE
Follow these steps
step 1 - Click on ...READ MORE
The error says you need to use ...READ MORE
You can use:
MonthName = FORMAT(DATE(1, [Num], 1), ...READ MORE
If the tables are related, this is ...READ MORE
In order to ignore Slicer you need ...READ MORE
You can do this in two ...READ MORE
If the one Drive is from your ...READ MORE
Already have an account? Sign in.