Data offset Issue

[mukhan169]

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 should calculate the IPTV uptill (current month -13) and for 24 month of service it should calculate IPTV uptill (current month -25).
For 3 MIS it should stop the IPTV on Oct 2018.

For 12 MIS 

And there shouldnt be any data for 24 MIS. I am uploading  the sample pbix file.

Sample

Thanks in advance for your help.

[v-shex-msft]

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]

@v-shex-msft  I am new to Dax can you provide me some examples please?

[mukhan169 · Accepted solution]

_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.