Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have the following manual entry excel report I am trying to build in Power BI
I'm going to use the "A Items No Stock" as my example.
I am using a DAX Calculate Count on itemNo but one of the filters is "inventory = 0"
That is pulling from the inventory level on the item card.
That is a calculated field that changes dynamically and has no date associated with it.
The data is coming from Business Central SaaS through a premium dataflow.
Two other examples are associated with Purchase Header and Purchase Line
Here is my DAX for Unconfirmed PO
I need to look at prior weeks. So in the example i need this measure calculated for 1/26, 1/19, 1/12, etc.
Also if I filter completelyReceived for any date prior it could be received by then meaning completelyReceived = true.
@bignadad , Join date(only date, no timestamp) of you table with date table
This is normal measure
Unconfirmed PO = CALCULATE(COUNT(purchaseHeader[no]),Filter(purchaseHeader, purchaseHeader[completelyReceived]=FALSE() && purchaseHeader[confRcvdFromVendor]=FALSE() && purchaseHeader[documentType]="ORDER"))
After 7 days
Unconfirmed PO next week= CALCULATE(COUNT(purchaseHeader[no]),Filter(purchaseHeader, purchaseHeader[completelyReceived]=FALSE() && purchaseHeader[confRcvdFromVendor]=FALSE() && purchaseHeader[documentType]="ORDER"), dateadd(Date[Date], 7 , day))
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8
Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |