Forum Discussion
can anyone help me on dax.
Here i am trying to get the sum of value to be displayed in the min of week of year.
Here i have measure like this
Asofstock = SUMX('D1e2e', 'D1e2e'[IHQTY] - 'D1e2e'[PCDQTY])
And i have cretaed another measure to display the o/p of above measure in the min of weekofyear,
OpenStock =
CALCULATE(
[Asofstock],
ALL('query1'),
'Query1'[Week of Year] = MIN('Query1'[Week of Year])
)
But i am getting like this the total value is being splitting by the weeks.
1 Reply
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
