Hi All,
Learnt few date functions in DAX
1 - To obtain Week Num = =WeekNum(DateColumn, 2)
2 - if you want day to start from Monday and 1 - if you want Sunday
2 - To obtain Month name
=Format(DateColumn,"MMM")
3 - To obtain Day name
=Format(DateColumn,"dddd")
Hi All,
Error while creating relationship between two tables in SSAS tabular model - RELATIONSHIP IS many to many relationship which is currently not supported.
To resolve this, create a bridge table and then establish One to many and Many to One relationship between the tables.
You may use the below DAX query to create Distinct value
=DISTINCT(D_EXCHANGERATE[CD_FROMCUR])
Enjoy coding!
