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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Alice_Cooper
Helper II
Helper II

Calculations based on Selected Date Selected and set Flags

 
Desperately need help -- been trying for days but can't crack it … 
 
EOMRPTLeaseStartDateEOMLeaseStartDateFinYearLeaseStartDateCalYearLeaseStartDateLeaseEndDateEOMLeaseEndDateFinYearLeaseEndDateCalYearLeaseEndDatePropertyIDSuburbResult1Result2Result3Result4Result5Result6
31/07/202221/06/202230/06/20222022202230/07/202231/07/2022202320221BUNDALL000110
31/07/20222/07/202230/06/20222022202215/01/202331/01/2023202320232BUNDALL000110
31/07/202231/07/202231/07/20222023202210/01/202331/01/2023202320233BUNDALL101010
31/07/20227/07/202231/07/2022202320227/07/202331/07/2023202420236SURFERS PARADISE101010
31/07/20225/07/202231/07/2022202320221/07/202531/07/20252026202534SURFERS PARADISE101010
31/08/20222/08/202231/08/2022202320222/08/202331/08/2023202420236SPRING HILL000000
31/08/20225/08/202231/08/2022202320225/08/202331/08/2023202420238NEW FARM101010
30/09/20221/09/202230/09/2022202320221/09/202330/09/2023202420239NORTH WARD111010
30/09/20229/09/202230/09/2022202320229/09/202330/09/20232024202313SMITHFIELD111010
30/09/202215/09/202230/09/20222023202215/09/202330/09/20232024202314RAILWAY ESTATE111010
31/07/20233/07/202331/07/2023202420233/01/202431/01/20242024202418INALA000000
31/07/20234/07/202331/07/2023202420234/01/202431/01/20242024202420RAILWAY ESTATE000000
31/07/20232/07/202331/07/2023202420232/07/202431/07/20242025202431CAPALABA000000
31/08/202329/07/202331/08/2023202420231/02/202429/02/20242024202422NORTH WARD000000
31/08/20232/08/202331/08/2023202420232/02/202429/02/20242024202423RAILWAY ESTATE000000
30/09/20231/09/202330/09/2023202420231/03/202431/03/20242024202424RAILWAY ESTATE000000
 
 
What I Need:
 
1. Filter so User Can Select EOMRPT
2. Based on this SELECTEDVALUE … lets call this NM-SEOMRPT and lets select 30/09/22
 
A Table that returns
 
a. Number Of Properties (Sum Distinct Property ID) from earliest EOMRPT to NM-SEOMRPT
b. Number of Properties (Sum Distinct Property ID) during NM-SEOMRPT
c. Number of Properties (Sum Distinct Property ID) for Financial Year To Date (Based on FinYearLeaseStartDate = the financial year of NM-SEOMRPT)
d. Number of Properties (Sum Distinct Property ID) for previous Financial Year (Based on FinYearLeaseStartDate = the financial year of NM-SEOMRPT), if no value return "N/A"
e. Number of Properties (Sum Distinct Property ID) for Calendar Year To Date (Based on CalYearLeaseStartDate = the financial year of NM-SEOMRPT)
f. Number  of Properties (Sum Distinct Property ID) for previous Calendar Year (Based on CalYearLeaseStartDate= the financial year of NM-SEOMRPT), if no value return "N/A"
 
Example User Selects 30/09/22 from EOMRPT so Selectedvalue for NM-SEOMRPT evaluates to = 30/09/22
 
I should get (see Check Table) for:
a.    9 Properties from earliest EOMRPT to 30/09/22 …... One Property ID 6 is a duplicate
b.    3 Properties during 30/09/22
c.    7 Properties Financial Year To Date (based on FinYearLeaseStartDate = 2023 financial year for 30/09/22 NM-SEOMRPT) …. One Property ID 6 is a duplicate
d.    2 Properties for previous Financial Year 2022
e.    9 Properties for Calendar Year To Date (Based on CalYearLeaseStartDate = the calendar year for 30/09/22 NM-SEOMRPT)  …... One Property ID 6 is a duplicate
f.    N/A Properties for previous Calendar Year (Based on CalYearLeaseStartDate= the calendar year of 30/09/22 NM-SEOMRPT)
 
I would like to flag each record that results in a match for the above conditions (Result1 ... Result6) with a value of 1 if it returns a value for the condition else 0. I will use this to graph and do other analysis
3 ACCEPTED SOLUTIONS

Good Point ...

 

This is what needs to Happen ...

 

If we select 31/07/23

 

For (Out-Properties with Lease End Date as at Financial Year To Date)

We need to count the Number of Properties in the Financial Year  to date (EOMRPT) 31/07/23 is Selected  ... so that means all properties with a (Lease End Date) betweem 1/07/23 to 31/07/24 

 

For (Out-Properties with Lease End Date in Previous Financial Year)

 

We need to count the Number of Properties in the Previous Year so if (EOMRPT) = 31/07/23 ... it means all properties with a (Lease End Date) betweem 1/07/22 to 30/06/23

 

 

BRAZIL OUT ....:(  Vai Portugal 🙂

 

 

 

 

View solution in original post

HI @Alice_Cooper ,

 

try the following codes:

 

Out-Properties with Lease End Date in Previous Financial Year = 
VAR OPFYYTD =
    CALCULATE (
        DISTINCTCOUNT ( Leases[Property ID] ),
        FILTER (
            
            
            ALL ( Leases ),
            Leases[EOMRPT]
                <= EOMONTH ( MAX ( EOMRPT[EOMRPT] ), 0 ) 
                && Leases[EOMRPT]
                    >= 
                        DATE ( YEAR ( MAX ( EOMRPT[EOMRPT] ) ) - 1, MONTH ( MAX ( EOMRPT[EOMRPT] ) ), 1 )
                       
                    )
        )
    
RETURN
    IF ( NOT ( ISBLANK ( OPFYYTD ) ), OPFYYTD, 0 )


Out-Properties with Lease End Date as at Financial Year To Date =
VAR OATFY =
    CALCULATE (
        DISTINCTCOUNT ( Leases[Property ID] ),
        FILTER (
            ALL ( Leases ),
            Leases[EOMRPT]
                >= EOMONTH ( MAX ( EOMRPT[EOMRPT] ), -1 ) + 1
                && Leases[EOMRPT]
                    <= EOMONTH (
                        DATE ( YEAR ( MAX ( EOMRPT[EOMRPT] ) ) + 1, MONTH ( MAX ( EOMRPT[EOMRPT] ) ), 1 ),
                        0
                    )
        )
    )
RETURN
    IF ( NOT ( ISBLANK ( OATFY ) ), OATFY, 0 )

Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

Hi @Alice_Cooper ,

 

Use the following measure:

Active Houses V1 =
COUNTROWS (
    CALCULATETABLE (
        Leases,
        Leases[Lease Start Date] <= MAX ( DimDate[End of Month] ),
        CROSSFILTER ( DimDate[Date], Leases[EOMRPT], NONE )
    )
)
    - COUNTROWS (
        CALCULATETABLE (
            Leases,
            Leases[Effective Lease End Date] <= MAX ( DimDate[End of Month] ),
            CROSSFILTER ( DimDate[Date], Leases[EOMRPT], NONE )
        )
    )

 

MFelix_0-1671278097275.png

Using the new measure has bubble size you get:

 

MFelix_1-1671278134395.png

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

37 REPLIES 37

Felix ... Please See Attached Spreadsheet ...(MyTestCheck.xls) and New Power Bi file ...

 

The following Measures are not returning the correct result:

 

In-Properties with Lease End Date as at Financial Year To Date

In-Properties with Lease End Date as at Financial Year To Date

 

Out-Properties with Lease End Date as at Financial Year To Date

Out-Properties with Lease End Date as at Financial Year To Date

 

I have tried to get the correct answer but have failed? Could you help me please?

Forgot the links Spreadsheet 

 

Libk to PowerBI File

Alice_Cooper
Helper II
Helper II

  My Power BI file can be fount at this link:  https://drive.google.com/file/d/199JevChzwhNhGU1zxHVUNo4pbfMYng4F/view?usp=share_link

 

My data is as follows:

The (Effective Lease End Dates) for EOMRPT 30/11/2022 falls in two calendar years 2024 & 2023 these are valid.

The same is for EOMRPT of 31/03/23 & 31/05/23

 

 

 

EOMRPT

Lease Start Date

Effective Lease End Date

CalYearLeaseEndDate

31/07/2022

7/07/2022

30/06/2023

2023

31/07/2022

10/07/2022

10/01/2023

2023

31/08/2022

2/08/2022

31/07/2023

2023

31/08/2022

5/08/2022

5/08/2023

2023

30/09/2022

1/09/2022

1/09/2023

2023

30/09/2022

9/09/2022

9/09/2023

2023

30/09/2022

15/09/2022

15/09/2023

2023

30/11/2022

11/11/2022

11/05/2024

2024

30/11/2022

22/11/2022

22/05/2023

2023

31/01/2023

4/01/2023

4/01/2024

2024

31/01/2023

5/01/2023

5/07/2023

2023

31/01/2023

10/01/2023

10/01/2024

2024

28/02/2023

2/02/2023

2/08/2024

2024

28/02/2023

4/02/2023

4/08/2024

2024

31/03/2023

1/03/2023

1/09/2023

2023

31/03/2023

2/03/2023

2/09/2023

2023

31/03/2023

4/03/2023

4/09/2023

2023

31/03/2023

5/03/2023

5/03/2024

2024

30/04/2023

1/04/2023

1/04/2024

2024

31/05/2023

2/05/2023

2/05/2024

2024

31/05/2023

4/05/2023

4/05/2024

2024

31/05/2023

5/05/2023

5/11/2023

2023

30/06/2023

1/06/2023

1/12/2023

2023

30/06/2023

2/06/2023

2/12/2023

2023

31/07/2023

2/07/2023

2/07/2024

2024

31/07/2023

3/07/2023

3/01/2024

2024

31/07/2023

4/07/2023

4/01/2024

2024

31/08/2023

1/08/2023

1/02/2024

2024

31/08/2023

2/08/2023

2/02/2024

2024

30/09/2023

1/09/2023

1/03/2024

2024

 

 

The code :

 

Out-Properties with Lease End Date in Calendar Year = CALCULATE (

    DISTINCTCOUNT ( Leases[Property ID] ),

    FILTER (

        ALL ( Leases ),

        Leases[EOMRPT]

            >= MINX (

                FILTER (

                    ALL ( Leases ),

                    Leases[CalYearLeaseEndDate]

                        = LOOKUPVALUE (

                            Leases[CalYearLeaseEndDate],

                            Leases[EOMRPT], MAX ( EOMRPT[EOMRPT] )

                        )

                ),

                Leases[EOMRPT]

            )

            && year(Leases[EOMRPT]) <= MAX (EOMRPT[EOMRPT] )

            && Leases[CalYearLeaseEndDate]

                = LOOKUPVALUE (

                    Leases[CalYearLeaseEndDate],

                    Leases[EOMRPT], MAX ( EOMRPT[EOMRPT])

                )

    )

)

 

 

Error Message:

MdxScript(Model) (252, 21) Calculation error in measure 'Leases'[Out-Properties with Lease End Date in Calendar Year]: A table of multiple values was supplied where a single value was expected.

 

But the data is correct …

 

If we select EOMRPT as 30/11/2022 we want to test if the CalYearLeaseEndDate is equal to 2022 in this case, it should return Zero.

 

If If we select EOMRPT as 31/03/2023 we want to test if the CalYearLeaseEndDate is equal to 2023 in this case, it should return three.

 

OK Miguel.

 

This is what I need:

 

If I select the EOMRPT as 31/03/23 I want to be able to count how many leases started in the calendar year and how many ended in the calendar year.

 

I should get 9 Started

(IN-Properties with Lease Start Date in Calendar Year)

and 12 Ended

(Out-Properties with Lease End Date in Calendar Year)

…. Therefore, I can say that I have 3 (12-9) active leases…

 

Bal-Active Leases During Calendar Year = (Out-Properties with Lease End Date in Calendar Year)- (Out-Properties with Lease End Date in Calendar Year)

Hi @Alice_Cooper ,

 

The file is giving an error when trying to download it can you check the link you provided?


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



My appologies ... Here it is ...MyTestBi 

 

Jogao do Portugal ... foi maravilhoso .... Meu avo, infelizmente falecido, era de Lisboa ... Vamos Portugal...

Alice_Cooper
Helper II
Helper II

Miguel,

 

Here is a link to the POWER BI that I have been working on ... when I select 30/11/22, 31/01/23, 31/03/23, 31/05/23 or 31/01/23 I get the 

 

Error Message:
MdxScript(Model) (50, 21) Calculation error in measure 'Leases'[Properties YTD]: A table of multiple values was supplied where a single value was expected.

 

The data is correct as I can have multiple leases with different Start and End Date for each EOMRPT  ...

 

Not sure how to fix ... I have been trying but cannot work it out ... as it will not allow me to have expressions using MAX???

 

THE LINK :  MyTestBI 

Alice_Cooper
Helper II
Helper II

This is what I need:

 

If I select the EOMRPT as 31/03/23 I want to be able to count how many leases started in the calendar year and how many ended in the calendar year.

 

I should get 9 Started

(IN-Properties with Lease Start Date in Calendar Year)

and 12 Ended

(Out-Properties with Lease End Date in Calendar Year)

…. Therefore, I can say that I have 3 (12-9) active leases…

 

Bal-Active Leases During Calendar Year = (Out-Properties with Lease End Date in Calendar Year)- (Out-Properties with Lease End Date in Calendar Year)

Alice_Cooper
Helper II
Helper II

Miguel,

I have a problem. My data is as follows:

The (Effective Lease End Dates) for EOMRPT 30/11/2022 falls in two calendar years 2024 & 2023 these are valid.

The same is for EOMRPT of 31/03/23 & 31/05/23

 

 

 

EOMRPT

Lease Start Date

Effective Lease End Date

CalYearLeaseEndDate

31/07/2022

7/07/2022

30/06/2023

2023

31/07/2022

10/07/2022

10/01/2023

2023

31/08/2022

2/08/2022

31/07/2023

2023

31/08/2022

5/08/2022

5/08/2023

2023

30/09/2022

1/09/2022

1/09/2023

2023

30/09/2022

9/09/2022

9/09/2023

2023

30/09/2022

15/09/2022

15/09/2023

2023

30/11/2022

11/11/2022

11/05/2024

2024

30/11/2022

22/11/2022

22/05/2023

2023

31/01/2023

4/01/2023

4/01/2024

2024

31/01/2023

5/01/2023

5/07/2023

2023

31/01/2023

10/01/2023

10/01/2024

2024

28/02/2023

2/02/2023

2/08/2024

2024

28/02/2023

4/02/2023

4/08/2024

2024

31/03/2023

1/03/2023

1/09/2023

2023

31/03/2023

2/03/2023

2/09/2023

2023

31/03/2023

4/03/2023

4/09/2023

2023

31/03/2023

5/03/2023

5/03/2024

2024

30/04/2023

1/04/2023

1/04/2024

2024

31/05/2023

2/05/2023

2/05/2024

2024

31/05/2023

4/05/2023

4/05/2024

2024

31/05/2023

5/05/2023

5/11/2023

2023

30/06/2023

1/06/2023

1/12/2023

2023

30/06/2023

2/06/2023

2/12/2023

2023

31/07/2023

2/07/2023

2/07/2024

2024

31/07/2023

3/07/2023

3/01/2024

2024

31/07/2023

4/07/2023

4/01/2024

2024

31/08/2023

1/08/2023

1/02/2024

2024

31/08/2023

2/08/2023

2/02/2024

2024

30/09/2023

1/09/2023

1/03/2024

2024

 

 

The code :

 

Out-Properties with Lease End Date in Calendar Year = CALCULATE (

    DISTINCTCOUNT ( Leases[Property ID] ),

    FILTER (

        ALL ( Leases ),

        Leases[EOMRPT]

            >= MINX (

                FILTER (

                    ALL ( Leases ),

                    Leases[CalYearLeaseEndDate]

                        = LOOKUPVALUE (

                            Leases[CalYearLeaseEndDate],

                            Leases[EOMRPT], MAX ( EOMRPT[EOMRPT] )

                        )

                ),

                Leases[EOMRPT]

            )

            && year(Leases[EOMRPT]) <= MAX (EOMRPT[EOMRPT] )

            && Leases[CalYearLeaseEndDate]

                = LOOKUPVALUE (

                    Leases[CalYearLeaseEndDate],

                    Leases[EOMRPT], MAX ( EOMRPT[EOMRPT])

                )

    )

)

 

 

Error Message:

MdxScript(Model) (252, 21) Calculation error in measure 'Leases'[Out-Properties with Lease End Date in Calendar Year]: A table of multiple values was supplied where a single value was expected.

 

But the data is correct …

 

If we select EOMRPT as 30/11/2022 we want to test if the CalYearLeaseEndDate is equal to 2022 in this case, it should return Zero.

 

If If we select EOMRPT as 31/03/2023 we want to test if the CalYearLeaseEndDate is equal to 2023 in this case, it should return three.

 

Is there a way for this to work?

MFelix
Super User
Super User

Hi @Alice_Cooper 

 

First of all add a table that you use has a slicer with the EOMRP values

Add the following measures:

Earliest properties = CALCULATE (
    DISTINCTCOUNT ( Leases[PropertyID] ),
    FILTER ( ALL ( Leases ), Leases[EOMRPT] <= MAX ( DAteFilter[EOMRPT] ) )
)

Number of properties = CALCULATE (
    DISTINCTCOUNT ( Leases[PropertyID] ),
    Leases[EOMRPT] = MAX ( DAteFilter[EOMRPT] )
)

Properties PY YTD = VAR PYYTD =
    CALCULATE (
        DISTINCTCOUNT ( Leases[PropertyID] ),
        FILTER (
            ALL ( Leases ),
            Leases[EOMRPT]
                >= MINX (
                    FILTER (
                        ALL ( Leases ),
                        Leases[FinYearLeaseStartDate]
                            = LOOKUPVALUE (
                                Leases[FinYearLeaseStartDate],
                                Leases[EOMRPT], MAX ( DAteFilter[EOMRPT] ) - 1
                            )
                    ),
                    Leases[EOMRPT]
                )
                && Leases[EOMRPT] <= MAX ( DAteFilter[EOMRPT] )
                && Leases[FinYearLeaseStartDate]
                    = LOOKUPVALUE (
                        Leases[FinYearLeaseStartDate],
                        Leases[EOMRPT], MAX ( DAteFilter[EOMRPT] )
                    ) - 1
        )
    )
RETURN
    IF ( NOT ( ISBLANK ( PYYTD ) ), PYYTD, "N/A" )

Properties PY YTD cal year = VAR PYYTD =
    CALCULATE (
        DISTINCTCOUNT ( Leases[PropertyID] ),
        FILTER (
            ALL ( Leases ),
            Leases[EOMRPT]
                >= MINX (
                    FILTER (
                        ALL ( Leases ),
                        Leases[CalYearLeaseStartDate]
                            = LOOKUPVALUE (
                                Leases[CalYearLeaseStartDate],
                                Leases[EOMRPT], MAX ( DAteFilter[EOMRPT] )
                            )
                    ),
                    Leases[EOMRPT]
                ) - 1
                && Leases[EOMRPT] <= MAX ( DAteFilter[EOMRPT] )
                && Leases[CalYearLeaseStartDate]
                    = LOOKUPVALUE (
                        Leases[CalYearLeaseStartDate],
                        Leases[EOMRPT], MAX ( DAteFilter[EOMRPT] ) - 1
                    )
        )
    )
RETURN
    IF ( NOT ( ISBLANK ( PYYTD ) ), PYYTD, "N/A" )

Properties YTD = CALCULATE (
    DISTINCTCOUNT ( Leases[PropertyID] ),
    FILTER (
        ALL ( Leases ),
        Leases[EOMRPT]
            >= MINX (
                FILTER (
                    ALL ( Leases ),
                    Leases[FinYearLeaseStartDate]
                        = LOOKUPVALUE (
                            Leases[FinYearLeaseStartDate],
                            Leases[EOMRPT], MAX ( DAteFilter[EOMRPT] )
                        )
                ),
                Leases[EOMRPT]
            )
            && Leases[EOMRPT] <= MAX ( DAteFilter[EOMRPT] )
            && Leases[FinYearLeaseStartDate]
                = LOOKUPVALUE (
                    Leases[FinYearLeaseStartDate],
                    Leases[EOMRPT], MAX ( DAteFilter[EOMRPT] )
                )
    )
)

Properties YTD calendar yaer = CALCULATE (
    DISTINCTCOUNT ( Leases[PropertyID] ),
    FILTER (
        ALL ( Leases ),
        Leases[EOMRPT]
            >= MINX (
                FILTER (
                    ALL ( Leases ),
                    Leases[CalYearLeaseStartDate]
                        = LOOKUPVALUE (
                            Leases[CalYearLeaseStartDate],
                            Leases[EOMRPT], MAX ( DAteFilter[EOMRPT] )
                        )
                ),
                Leases[EOMRPT]
            )
            && Leases[EOMRPT] <= MAX ( DAteFilter[EOMRPT] )
            && Leases[CalYearLeaseStartDate]
                = LOOKUPVALUE (
                    Leases[CalYearLeaseStartDate],
                    Leases[EOMRPT], MAX ( DAteFilter[EOMRPT] )
                )
    )
)

 

Result below:

MFelix_0-1669923546293.png

 

I only have questions about your last remark about the flag what do you need to get the result?Is the one that appears on the columns resut one to six? 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Brilliant! 😲

Ola Miguel,

Eu so Brasiliero moro aqui na Australia ... Muinto Obrigado ...

 

Voce Poderia me mandar o ficheiro (file) de Power BI ..? Desculpa o portugues estao morand en Australia masi de 40 anos ... 

 

Abraco..... Vai Brazil Copa 2022

Boa tarde @Alice_Cooper ,

 

Eu sou de Portugal.

 

Segue o ficheiro em anexo tal como pedido.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Thank you Miguel,

 

I notice that this error on selection 31/07/22

 

 

Error Message:
MdxScript(Model) (50, 21) Calculation error in measure 'Leases'[Properties YTD]: A table of multiple values was supplied where a single value was expected.

Hi @Alice_Cooper ,.

 

This is regarding your data believe you have an error on the data becuase the FinYerStartDate has different values in this case 2022 / 2023

 

MFelix_0-1670231966748.png

 

Taking into accoutn the data it should all have the same date correct?


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Thank you Miguel,

 

I see it now July 2 2022 should be EOMLeaseStartDate July 31 2023 and FinYearLeaseStartDate 2023

 

LeaseStartDate Jun 22 2022 is correct EOMLeaseStartDate Jun 30 2022 and FinYearLeaseStartDate 2022 ...

 

Thank you ...

 

I will run some code over the data to check all records ...

 

Did you get a chance to help me out with the flags?

 

Thank you 

Thank you Miguel,

 

I will try out your solution later today ...

 

In terms of Results 1 to 6

 

I need a Flag for records that:

match condition a. (Result 1)

match condition b. (Result 2)

match condition c. (Result 3)

match condition d. (Result 4)

match condition e. (Result 5)

match condition f. (Result 6)

 

What I put in the table sis the result I expect ... 

 

The flags will be used to do further calculations, without the need for complex Dax ... for example 

 

Result3 (Condition c. Properties Financial Year To Date) and

Result4 (Condition d. Properties for previous Financial Year)

 

I could calculated (using the Flags)  (sum(Result3)/sum(Result4))*100  to get %

 

I would also like the flags to be able to quickly pull graphs together ...

 

I hope thsi clarifies ...

 

Are you able to show me how to returmn the value of 1 when the conditions in (a) through (f) are met?

 

Thank you 

Ola Miguel,

 

Esperamos que of final da Copa Mundial seja cheio de alegria para Brazil o Portugal?

 

Munito obrigado pelo Ficheiro ... 

 

Voce tem oportunidade para me a judar con a segunda parte do problema?

 

The Flags ....?  Results1 a Result6 ...

 

Munito Obrigado....

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.