Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Regards,
Xiaoxin Sheng
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |