I hope someone can help me.
I am trying to make a profitabillity analysis of jobs/projects with data from dynamics NAV:
I have a year slicer (Dimdate table), but the sale amounts and cost amounts of a job must first be included in the report, when the finished date is in the year, we have sliced to. Example: we have a job/project which streches over a 2 year period (som costs and sales are posted in 2018 and some cost and sales are posted in 2019), and the finished date (DimJob table) is in 2019 and therefor should all the job/projects cost and sales (2018 and 2019) be shown, when I slice to year 2019.
I have tried :
Afsluttet dato = finished date
Kostbeløb = cost amount
I can't find the dates when I just use "IF", therefor I need MAX??
I have made a new coloumn in data, where i have lookupvalue on finished date from dimjob table to factjob table.
I appreciate this community and hope someone can help me!
first remove the dates from the MAX function and move them outside MAX example MAX () <= Dates and then remove the CALCULATE before MAX, that's not doing anything.
Thanks, but now the dax function return 0 for every job, so it do not solve it all.
Bogføringsdato = Posting date
I will not slice bye month, only year. I want the dax to includ all the costs and sales if the project has a finished date between 01-01-2020 and 31-12-2020. Some of the cost can be posted the year before and must be included when the projects finished date is in sliced year.
Can you utilize a contract to date or inception to date formula? This would remove the filter context and introduce one that does not factor in the year slicer. The visual could still be filtered by the finish date.
Find out who's part of the program this season, and welcome the new Super Users.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Learn about the exciting things that happened in July.
All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.
Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.