Forum Discussion
Dynamic filter - Month Semestre
Hello, I have two tables, Table date and Sales (and others but it's not the point). The probleme is that I don't have the sales by date but only by semestre. (But I use other tables with dates) ...
Hi Anonymous ,
I made a simple sample you can refer to.
Create a calculated column and create a relationship between tables.
Semestre = SWITCH(TRUE(),[MonthNum] in {1,2,3,4},"Semestre 1",[MonthNum] in {5,6,7,8},"Semestre 2",[MonthNum] in {9,10,11,12},"Semestre 3")Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
I made a simple sample you can refer to.
Create a calculated column and create a relationship between tables.
Semestre = SWITCH(TRUE(),[MonthNum] in {1,2,3,4},"Semestre 1",[MonthNum] in {5,6,7,8},"Semestre 2",[MonthNum] in {9,10,11,12},"Semestre 3")
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.