Assistance in a simple Report

Jaweed — Tue, 23 Apr 2024 09:58:00 GMT

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 your assistance.

Output

I want the report to have first a table showing the company details. A second table below will show its shareholders only ( based on the Company selected)

Parameters: ( 2 of them)

1: Drop box of complanies as per data input in parameter 2, which is a Next Review Date. Only companies with Next Review Date <= "User input date ie [arameter 2" gets populated'

In my example, user choses 30 April 2024 in parameter 2, Only CPY A and Cpy B get populated in parameter 1. User selects CPY A and the shareholder table is filtered accordingly.

Sample Data

Table Company
Company	Next Review Date	Manager
CPY A	12-Feb-24	Lee
CPY B	18-Jan-24	Rob
CPY C	12-May-24	Sue
CPY D	18-Jun-24	Suzy

Table ShareHolder
Company	ShareHolder Name
CPY A	Jack
CPY A	Mary
CPY B	Helen
CPY C	Jelly
CPY C	Francis
Report Layout
Company basic
Company	Manager
CPY A	LEE
Shareholders
Company	Shareholder Name
CPY A	Jack
CPY A	Mary

Re: Assistance in a simple Report

Anonymous — Wed, 24 Apr 2024 01:28:02 GMT

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.

topic Re: Assistance in a simple Report in Report Server

Assistance in a simple Report

Re: Assistance in a simple Report