I have a set of dates and looking to identify period "2021P01" using multiple condition in PowerBI. Basically I want if date>=1/1/2021 and less than <=1/31/2021 the it should give the out as "2021P01"
I used this function but getting blank values Period = SWITCH(TRUE(),AND('Calendar'[Date]>=1/1/2021,'Calendar'[Date]<=1/31/2021),"2021P01",BLANK())
Please help me with a solution