Share via

Facing error in DAX formula

Anonymous
2024-10-03T03:07:26+00:00

=

VAR Start_Date = 

MIN ( data[Start] )

VAR End_Date = 

MAX ( data[End] )

VAR Column_Date = 

MAX ( 'Calendar'[Date] )

RETURN 

IF ( Start\_Date <= Column\_Date && End\_Date >= Column\_Date, 1, BLANK )
Microsoft 365 and Office | Install, redeem, activate | Other | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-10-03T14:45:59+00:00

    Hello Dharm Dutt,

    Thank you for visiting the Microsoft Community.

    You've encountered an issue related to the Microsoft Power BI. However, there is less Power BI-related knowledge in the community, so I suggest you post this issue in the appropriate section of Microsoft Fabric Community Power Query - Microsoft Fabric Community, where more experienced professionals can offer advice.

    I will keep this thread open in anticipation of our wonderful volunteers who will provide assistance to them.

    Best regards

    Jonathan Z - MSFT | Microsoft Community Support Specialist

    Was this answer helpful?

    0 comments