topic Re: Calculation of Quartes in DAX Commands and Tips

Calculation of Quartes

Carlo1975 — Mon, 23 Nov 2020 14:08:52 GMT

Hi everyone, I have a problem, that is, I should calculate the quarters with respect to connected columns. The columns are Name, first date and second date.I think that is very difficult, but I try to explain

The First and the second Date aren’t in order
2) The quarter is equal to 0 as long as the first date is less than the second date. After that, when the first date is equal to or greater than the second date, I start counting the quarters based on the first date. In the example 30/06/2018 is the date to start calculating the first quarter and in fact it is equal to 1. After the 3 months, in the example it is 30/10/2018 it becomes quarter 2 .... so until the end
When the name changes, we start from scratch again.

Name	First Date	Second Date	Quarter
XXXX	31/05/2018	30/06/18	0
XXXX	31/05/2018	30/06/18	0
XXXX	30/06/2018	30/06/18	1
XXXX	30/06/2018	30/06/18	1
XXXX	30/06/2018	30/06/18	1
XXXX	31/10/2018	30/06/18	2
XXXX	31/10/2018	30/06/18	2
YYYYYYYY	31/05/2018	30/06/18	0
YYYYYYYY	31/05/2018	30/06/18	0
YYYYYYYY	31/05/2018	30/06/18	0

Thank you

Carlo

Re: Calculation of Quartes

amitchandak — Mon, 23 Nov 2020 15:21:28 GMT

Carlo1975 , Create a new column like

Switch( true(),
[First Date]<[Second Date], 0 ,
[First Date]=[Second Date], 1 ,
[First Date]>[Second Date], 2
)

Re: Calculation of Quartes

Carlo1975 — Mon, 23 Nov 2020 15:57:09 GMT

I'm sorry but is wrong...if you look my example, when the first date is 30/10/2018, the quarter is 2, but, if for example I have also another data like 31/01/2019, the quarter will be 3, and if I have also 31/04/2019 the quarter will be 4....and so on until the name change. Each 3 month, from the first date is equal or greater than the second date, I have to add 1 (quarter 1, quarter 2, quarter 3, quarter 4, quarter 5, etc.)