Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How can i count the null values for max month from this pivot table?
expression: Sum({<Kontonr={4297,4298,4299}>}[Bokført beløp])
Think that you need to construct a cartesian product betw accounts and month. Then you should be able to count all non-occurences within selected monthes.
Peter
Hi, Thanks for reply
Got an example for that?
just as aircode:
RunningCalendar: LOAD MONTH(Date) AS Maned INLINE (Date
1/1/2017
1/2/2017
1/3/2017
1/4/2017
......];
JOIN LOAD (RunningCalendar) DISTINCT Account FROM ....;
With this you should have a big table with an entry for each Month and existing Account.
Peter
Hello, Marius!
You can check this topic:
You can use expressions from there and modify them with maxdate condition, and you should get what you are lookin for.