Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am working with a data set that looks like the below. I have two tables one with sales data by m445 week and the other is simply a date table for the 445 unique calendar that has every day and shows the week associated with that day. I want to automatically filter out weeks where the Current Year Sales for those weeks are blank in the data set as there are no sales becasue that week has not happened yet. Below is simple mock up of what the data sort of looks like. so, in the below picture I would want to automatically filter out the weeks 2020051through 2020062. Thanks for any help!!!
Sales CY = sum(sales_CY) | Sales PY = sum(sales_PY) | |||
related date table | ||||
Week # | M445WK | Sales CY | Sales PY | |
1 | 2020011 | 133 | 133 | |
2 | 2020012 | 153 | 153 | |
3 | 2020013 | 173 | 173 | |
4 | 2020014 | 193 | 193 | |
5 | 2020021 | 213 | 213 | |
6 | 2020022 | 233 | 233 | |
7 | 2020023 | 253 | 253 | |
8 | 2020024 | 273 | 273 | |
9 | 2020031 | 293 | 293 | |
10 | 2020032 | 313 | 313 | |
11 | 2020033 | 333 | 333 | |
12 | 2020034 | 353 | 353 | |
13 | 2020035 | 373 | 373 | |
14 | 2020041 | 393 | 393 | |
15 | 2020042 | 413 | 413 | |
16 | 2020043 | 433 | 433 | |
17 | 2020044 | 453 | 453 | |
18 | 2020051 | 473 | ||
19 | 2020052 | 493 | ||
20 | 2020053 | 513 | ||
21 | 2020054 | 533 | ||
22 | 2020061 | 553 | ||
23 | 2020062 | 573 |
Solved! Go to Solution.
You can use IF Function with your Regular Funciton
IF(ISBLANK(your measure) , Blank(), your measure) Try and let me know
also you can wathc my videos on www.youtube.com/perepavijay
Proud to be a Super User!
Try create a column as a slicer,
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You can use IF Function with your Regular Funciton
IF(ISBLANK(your measure) , Blank(), your measure) Try and let me know
also you can wathc my videos on www.youtube.com/perepavijay
Proud to be a Super User!
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |