Is Current Quarter Conditional Column

[Anonymous]

Hi, 

I have a date table that includes the Quarter (Q1 - Q4) based on the date field. 

I want to create a conditional column that gives me a (1) if the date is in the current quarter, and a (0) if else. 

How do I do this using DAX?

[az38 · Accepted solution]

Hi @Anonymous 

try column

Column = 
if(
FORMAT('Table'[Date];"yyyy q") = FORMAT(today();"yyyy q");
1;
0
)

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn