Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
I have an Excel list from SAP system that contains purchased items with their PO Date and their estimated delivered date.
I'm trying to do some simple reporting which I will have a date slicer, and whenever a user specifies the start date and end date; the report will show (1) all purchased items in period from slicer (via PO date) and also (2) purchased items with estimated delivered date in period from slicer.
I've seem to be able to achieve it in the table visual below:
The "PO Date" and "Delivery date" are original columns from data source. "Start Date from Slicer", "End Date from Slicer" and "Delivery date between Slicer Dates" are all using Measures.
What I want to do now is to count how many rows are "Yes" in "Delivery date between Slicer Dates". I've tried using this measure but it returns Blank
Count of Yes = COUNTROWS ( FILTER ( SUMMARIZE ( SAP DATA, SAP DATA[PO Date], "Yes", [Delivery date between slicer dates] ), [Delivery date between slicer dates] = "Yes" ) )
Any recommendation?
By the way sorry if this is repeating. I've already tried referring here but to no avail:
https://community.powerbi.com/t5/Desktop/Table-visual-rows-count/td-p/448336
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Try Like
measure =
var _min = minx(Date,Date[Date])
var _max = maxx(Date,Date[Date])
return
if(max(table[Delivery_date])>=_min && max(table[Delivery_date])<=_max,"Yes","No")
Hi,
Share some dummy data in a PBI file and show the expected result there.
@Ashish_Mathur Im not sure how to share the pbix file here, but Ive put up a pbix file with its pbix file on my Google Drive.
https://drive.google.com/open?id=1FVBVSF99OlrmDvPeUFxOBmReF4SQM_Hu
Hi,
You may download my PBI file from here.
Hope this helps.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
83 | |
76 | |
65 |
User | Count |
---|---|
120 | |
112 | |
94 | |
84 | |
75 |