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 Team,
Need your expertise!
I have net cases number pulled from daily invoice database. I want to show the net cases in the table is as the table below as separate view based on the date range. However, I have using the measure as below but get the net cases combined instead of separated view as table1. Can you please help how to adjust my measure to get it to work? Thanks.
NetCasesRFP = calculate(sum('summary InvoiceDCByDay'[NetCases]),filter('Pricing',average('summary InvoiceDCByDay'[InvoiceDate])>=Pricing[Valid After] && average('summary InvoiceDCByDay'[InvoiceDate])<=Pricing[Valid Before]))
Table 1
Net Cases | Price Start Date | Price End Date |
100 | 4/1/2019 | 5/1/2019 |
108 | 5/1/2019 | 6/1/2019 |
5 | 6/1/2019 | 7/1/2019 |
Table now
Hello Team,
I have net cases number pulled from daily invoice database. I want to show the net cases in the table is as the table below as separate view based on the date range. However, I have using the measure as below but get the net cases combined instead of separated view in the table. Can you please help how to adjust my measure to get it to work? Thanks.
My measure for this one now:
NetCasesRFP = calculate(sum('summary InvoiceDCByDay'[NetCases]),filter('Pricing',average('summary InvoiceDCByDay'[InvoiceDate])>=Pricing[Valid After] && average('summary InvoiceDCByDay'[InvoiceDate])<=Pricing[Valid Before]))
Net Cases | Price Start Date | Price End Date |
4/1/2019 | 5/1/2019 | |
213 | 5/1/2019 | 6/1/2019 |
6/1/2019 | 7/1/2019 |
Solved! Go to Solution.
Hello @GilbertQ ,
Thanks for your reply,
I create the measure below to show the net cases by the date range I select:
NetCases1 | Price Start Date | Price End Date |
213 | 4/1/2019 | 5/1/2019 |
213 | 5/1/2019 | 6/1/2019 |
213 | 6/1/2019 | 7/1/2019 |
I have two date sliicer, one is valid after to get the max day of Price Start Date, second one is Valid before to get the min of price End date.
The NetCase1 number is from the invoice date in between of the price start date and price end date.
*I am looking for a measure to show the net cases row by row by the day range I select like this below:
NetCases1 | Price Start Date | Price End Date |
100 | 4/1/2019 | 5/1/2019 |
108 | 5/1/2019 | 6/1/2019 |
5 | 6/1/2019 | 7/1/2019 |
Thank you very much!
Hello commnunity,
I have a measure question regarding date period,
In the measure, it works perfect if I have two date period that one is after and the other one is before.
Adjusted Cases = CALCULATE (
SUM ( 'summary InvoiceDCByDay'[NetCases]),
FILTER (
ALL ( 'summary InvoiceDCByDay'[InvoiceDate],'summary InvoiceDCByDay'[Brand],'summary InvoiceDCByDay'[Supplier],'summary InvoiceDCByDay'[Distribution Center] ),
('summary InvoiceDCByDay'[Distribution Center]) = max(Pricing[DCLocationName]) && ('summary InvoiceDCByDay'[Supplier]) = MAX(Pricing[MainItemSupplierName])
&& ('summary InvoiceDCByDay'[brand]) = max(Pricing[Brand])
&& ('summary InvoiceDCByDay'[InvoiceDate]) >= ([ValidAfterSelected])
&& ('summary InvoiceDCByDay'[InvoiceDate]) <= ([ValidBeforeSelected]))) + 0
Now, I want to just adjust the measure above and disreagard the validafter period and change the valid before from the "before" date slicer to "between" date slicer.
How can I addjust my measure above based on the valid after "between" slicer?
Thanks,
Kevin
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.