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")
If you wish to master Power BI Concepts, Check out Power BI Course Topics now!
1. Go to Modelling ribbon -> Manage ...READ MORE
Follow the below steps:
Create a column with ...READ MORE
If the one Drive is from your ...READ MORE
You can give them the same display ...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
Click on edit queries after loading source ...READ MORE
so you are using the raw source ...READ MORE
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.