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.
Thanks in advance for your help.
Solved! Go to Solution.
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.