Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Everyone,
I have an issue with dates calculations :
I try to evaluate a stock at different dates. To do so I have two files : one with the stock evaluated today and another one with the required quantities and the dates corresponding.
To decide the date at which I want to see the state of the stock, I use a slicer "before" with all the dates from a date table.
However, when I do not have any requirements before the date selected, the line is completely removed from my matrix (which I don't want, I would rather have the stock as it is now).
How can I force Power BI to display the line even if there are no data?
Here is when I have a requirement within the period selected , but if I go 10 days before, the line doesn't appear anymore.
I also give you the measures that I use :
Solved! Go to Solution.
@Anonymous +0 or show item with no data , may help to show data
Stock reel - BOM = CALCULATE(SUMX('Stock usine','Stock usine'[Stock usine] - [Pack requirements **bleep** - BOM]), FILTER('Bill of Materials','Bill of Materials'[(BOM) Base Component]), FILTER(ALL(DateTable),DateTable[Date] <= MAX(DateTable[Date])))+0
Pack requirements **bleep** - BOM = CALCULATE(SUMX('Packaging needs','Packaging needs'[Requirement Quantity (ERFME)]),FILTER(ALL(DateTable),DateTable[Date] <= MAX(DateTable[Date])), FILTER('Bill of Materials','Bill of Materials'[(BOM) Base Component])) +0
@Anonymous +0 or show item with no data , may help to show data
Stock reel - BOM = CALCULATE(SUMX('Stock usine','Stock usine'[Stock usine] - [Pack requirements **bleep** - BOM]), FILTER('Bill of Materials','Bill of Materials'[(BOM) Base Component]), FILTER(ALL(DateTable),DateTable[Date] <= MAX(DateTable[Date])))+0
Pack requirements **bleep** - BOM = CALCULATE(SUMX('Packaging needs','Packaging needs'[Requirement Quantity (ERFME)]),FILTER(ALL(DateTable),DateTable[Date] <= MAX(DateTable[Date])), FILTER('Bill of Materials','Bill of Materials'[(BOM) Base Component])) +0
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |