Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I would like to get rid of first row (equipment which have no assigned date from them) out of calculation [Number of Distinct EQ by prod date], so start counting from Jan2010 (capture1), as for instance SQL is doing (capture 2)
My current measure is:
Any ideas?
Hello @Pbiuserr ,
You could remove the blank from the Monthyear column from the filter pane.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
Hey
Will it change the calculation also?
User | Count |
---|---|
98 | |
90 | |
84 | |
70 | |
66 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |