Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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) ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Can you convert Semestre  to date

 

a new column like

switch(true() ,

[Semestre] ="Semestre  1" , date([year],1,1),

[Semestre] ="Semestre  2" , date([year],4,1),

[Semestre] ="Semestre  3" , date([year],7,1),

[Semestre] ="Semestre  4" , date([year],10,1)

)

 

I usually prefer to allocate. an example

Distributing/Allocating the Yearly Target(Convert to Daily Target): https://community.powerbi.com/t5/Community-Blog/Distributing-Allocating-the-Yearly-Target-Convert-to-Daily/ba-p/1463290