Forum Discussion

k1ko92's avatar
k1ko92
Regular Visitor
4 years ago

Problem many to many building dates

Hi Everyone,   I appreciate with you guys can help me with this DAX, I need to build a date (Ex : 20220213), using 2 tables. At column dax_YearMonthNo I need this date. Using this DAX Formula i cou...
Date
many to many
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

k1ko92 , for period you can get date like

 

date = date(left([period],4), right([period],2),1)

 

Or from calendar table

 

Minx(filter(calendar, calendar[Period] = table[Period]) , calendar[Date])

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.