Forum Discussion

mukhan169's avatar
mukhan169
Helper III
7 years ago
Solved

Data offset Issue

Thanks to   v-lili6-msft I have solve most of the issues. Just the following issue left.   I need to offset data. For 3 MIS it should calculate IPTV up till (current month-4), for 12 MIS it shou...
Need Help
  • mukhan169's avatar
    mukhan169
    7 years ago
     
     
    _maxdate =
    var ThreeMISCutoff =DATE(YEAR(NOW())|MONTH(NOW())-4|DAY(NOW()))
    var TwelveMISCutoff =DATE(YEAR(NOW())|MONTH(NOW())-12|DAY(NOW()))
    var TwentyFourMISCutoff =DATE(YEAR(NOW())|MONTH(NOW())-24|DAY(NOW()))
    return
    if(MAX(MIS[MIS])=3 && max(Dates[Date])<=ThreeMISCutoff|[IPTV]|

    IF(MAX(MIS[MIS])=12 && max(Dates[Date])<=TwelveMISCutoff|[IPTV]|
    IF(MAX(MIS[MIS])=24 && max(Dates[Date])<=TwentyFourMISCutoff|[IPTV]|
    if(MAX(MIS[MIS])=3 && max(Dates[Date])>=ThreeMISCutoff|[IPTV]|BLANK())
    )
    ))
     
     
    That did it. Please let me know if there is a better way.
     
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi mukhan169 ,

You can add if statement to check current row contains data and mis group, then use them to compare with today function to filter unmatched records.

Regards,

Xiaoxin Sheng

mukhan169's avatar
mukhan169
Helper III
7 years ago

Anonymous  I am new to Dax can you provide me some examples please?

  • mukhan169's avatar
    mukhan169
    Helper III
    7 years ago
     
     
    _maxdate =
    var ThreeMISCutoff =DATE(YEAR(NOW())|MONTH(NOW())-4|DAY(NOW()))
    var TwelveMISCutoff =DATE(YEAR(NOW())|MONTH(NOW())-12|DAY(NOW()))
    var TwentyFourMISCutoff =DATE(YEAR(NOW())|MONTH(NOW())-24|DAY(NOW()))
    return
    if(MAX(MIS[MIS])=3 && max(Dates[Date])<=ThreeMISCutoff|[IPTV]|

    IF(MAX(MIS[MIS])=12 && max(Dates[Date])<=TwelveMISCutoff|[IPTV]|
    IF(MAX(MIS[MIS])=24 && max(Dates[Date])<=TwentyFourMISCutoff|[IPTV]|
    if(MAX(MIS[MIS])=3 && max(Dates[Date])>=ThreeMISCutoff|[IPTV]|BLANK())
    )
    ))
     
     
    That did it. Please let me know if there is a better way.