Forum Discussion

OvaisJanzeb's avatar
OvaisJanzeb
Frequent Visitor
4 years ago

How to convent Column into Measure DAX

Hello, I want to convent this code into measure but able to do it with replace of fix number with selected value, Please can anyone help me out? Months in excel = IF(OR(ServiceModel[Month].[Year...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

OvaisJanzeb , Try new measure

 

new measure =
var _Date = max(ServiceMo[Month])
return
if( _date >= Date(2021,09,01) && _date <= DAte(2021,12,21), "Y", "N")