Forum Discussion
Missing value per period
Hello,
I've been trying to find the right formula and I can't find it:
I have a table A (Customers) and a table B (connections per month) and I try to find the customers who didn't connect in some months (present in B but in some months) or never (absent in table B).
Thanks for help.
Mus_PBI , Check if this link can help
https://www.dropbox.com/s/3wr697b3m57zufo/ExceptOther%20Tabl.pbix?dl=0
You can add filter to except to modify it
except(filter(Table1,...), filter(Table2,...))
5 Replies
- parry2k
Super User
Mus_PBI Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 - amitchandak
Mus_PBI , Check if this link can help
https://www.dropbox.com/s/3wr697b3m57zufo/ExceptOther%20Tabl.pbix?dl=0
You can add filter to except to modify it
except(filter(Table1,...), filter(Table2,...))
HI Mus_PBI,
It is hard to troubleshooting without any sample data. Please share some dummy data and expected results to help us clarify your requirement and test on it.
Regards,
Xiaoxin Sheng
FarhanAhmedCommunity Champion
One way is you can achieve is
Put following in Table /Matrix Visual
Select Customer from Customer Dimension (If not you need to create one)
Select Month from Date Dimension (If not you need to create one)
Select Connections from your table (Fact Table)
Filter "Connections" on the Visual to show Blank Values
Right Click Customer and Select "Show Items with no Data" and hopefully you will see your desired results.
Regards
