Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
HI,
I have table like this:
Date | Storage Bin |
1/2/2021 | BIN6 |
1/4/2021 | BIN7 |
2/5/2021 | BIN10 |
4/1/2021 | BIN7 |
5/8/2021 | BIN1 |
BIN2 | |
BIN3 | |
BIN4 | |
BIN5 | |
BIN6 | |
BIN7 | |
BIN8 | |
BIN9 | |
BIN10 |
When in my slicer filter when I select the date range 1/2/2021 to 2/5/2021, it should display all the bins in that range and also with the dates which are blanks,it should display not matching Bins.
My output should be:
Output: | comments |
BIN6 | |
BiN7 | |
BiIN10 | |
BIN2 | This is not matched Bin from the Blank dates |
BIN3 | This is non matched Bin from the Blank dates |
BIN4 | This is non matched Bin from the Blank dates |
BIN5 | This is non matched Bin from the Blank dates |
BIN8 | This is non matched Bin from the Blank dates |
BIN9 | This is non matched Bin from the Blank dates |
The Bins which has no date (BIN6 , BIN7 and BIN10, are matched one in our date selection, so we do not want to display it and duplicate.
Any help!
Solved! Go to Solution.
Comments measure : =
VAR _binlistindaterange =
VALUES ( Data[Storage Bin] )
VAR _allbinlistindatatable =
CALCULATETABLE ( VALUES ( Data[Storage Bin] ), ALL ( Dates[Date] ) )
RETURN
IF (
HASONEVALUE ( BINs[Storage Bin] ),
SWITCH (
TRUE (),
SELECTEDVALUE ( BINs[Storage Bin] ) IN _binlistindaterange, "",
SELECTEDVALUE ( BINs[Storage Bin] ) IN _allbinlistindatatable, BLANK (),
"This is not matched Bin from the Table"
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Comments measure : =
VAR _binlistindaterange =
VALUES ( Data[Storage Bin] )
VAR _allbinlistindatatable =
CALCULATETABLE ( VALUES ( Data[Storage Bin] ), ALL ( Dates[Date] ) )
RETURN
IF (
HASONEVALUE ( BINs[Storage Bin] ),
SWITCH (
TRUE (),
SELECTEDVALUE ( BINs[Storage Bin] ) IN _binlistindaterange, "",
SELECTEDVALUE ( BINs[Storage Bin] ) IN _allbinlistindatatable, BLANK (),
"This is not matched Bin from the Table"
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
84 | |
64 | |
52 | |
49 |
User | Count |
---|---|
211 | |
87 | |
80 | |
69 | |
60 |