Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
HI
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!
Best regards
Rune
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.
Thx, it worked (y)
BR
Rune
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.
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
Best regards
Rune Iversen