Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
DavidAgbai
New Member

How To calculate the Number of Event on a new column With Reference with Date

I have a date, Code and Number Of Event Column . The Logic is This - WHen You have BB or BV in the Code code Column There should BE "1" on the Number of Event Colum but if we have BB or BV on Two consucative Days WE want to have "1' for the first Day and '0" For the Second Day. Example 
Date| Code|Number Of Event 
1/1/2001| BB| 1
1/2/2001| BB| 0
1/7/2001| BB| 1
1/8/2001| BB| 0
1/12/2001|BB|1
Please How Can I implement this Logic With Dax . I have Tried This IF([Code]="BB",1,0,IF([Code]="BB",1,0)) But It didnt Work

3 REPLIES 3
aj1973
Community Champion
Community Champion

Hi @DavidAgbai 
Try this

IF([Code]="BB" || [Code]="BV",1,0)

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Did not Work 

 

IF(OR([Code]="BB" ,[Code]="BV"),1,0)

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors