Forum Discussion

Jaweed's avatar
Jaweed
Icon for Helper III rankHelper III
2 years ago
Solved

Assistance in a simple Report

Hi Everybody Please assist me, I am new to PowerBi Report services.  I have started designing a report based on a Powerbi data source.  I have 2 Tables - Company and Shareholders.  Thank you for yo...
needs help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Jaweed ,

     I have created a simple sample, please refer to my pbix file to see if it helps you.

    Create a date table .

    Table = CALENDAR(DATE(2024,4,1),DATE(2024,12,31))

    Then create a measure.

    Measure =
VAR _date =
    SELECTEDVALUE ( 'Table'[Date] )
RETURN
    IF ( MAX ( 'Table-company'[Next Review Date] ) <= _date, 1, BLANK () )

     

    How to Get Your Question Answered Quickly - Microsoft Fabric Community

     

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Rongtie

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Jaweed ,

 I have created a simple sample, please refer to my pbix file to see if it helps you.

Create a date table .

Table = CALENDAR(DATE(2024,4,1),DATE(2024,12,31))

Then create a measure.

Measure =
VAR _date =
    SELECTEDVALUE ( 'Table'[Date] )
RETURN
    IF ( MAX ( 'Table-company'[Next Review Date] ) <= _date, 1, BLANK () )

 

How to Get Your Question Answered Quickly - Microsoft Fabric Community

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.