File attached. Thanks
Thanks. Can you explain what the query is doing please so I can understand what each step is doing. The
As per my previous comments it appears I may have been making this more complicated by trying to use start date and status. What do you think? the...
Is there a way to do this from the source data? with Power Query or something else?
Being able to compare version numbers for a given date period would also be beneficial ie finding the max of the version number and comparing that w...
Thanks but this doesn't give me the answer. See my replies above - copied here for ease: The measure relationship to calendar needs to be based ...
When using the DAX syntax as described in the Power Pivot course in POWER BI it doesn't work when the dates are spread across years For POWER BI to...
I've got the measures [contracts expiring yr2] = CALCULATE([Total Contracts by Expiry Date],DATESBETWEEN(Dates[Date],"1/12/2017","30/11/2018")) ...
I think I was making this more complicated than it needs to be.... but I still can’t get it to work. The measure relationship to calendar needs to be...
Using the syntax with userelationship CALCULATE( SUM(ContractTable[ContractAmount] ), USERELATIONSHIP( ContractTable[Start...