You have a Power Bl model that contains two tables named Population and Date.
The Population table contains two columns named Population Amount and Date Key.
DateKey contains date values that represent the first day of a year and are used to create a many-to
The Power Bl model contains two measures that have the following definitions.
Total Population = Sum ('Population'[Population Amount])
2023 Population = CALCULATE ([Total Population]'Date'[Year] = 2023)
You create a table visual that displays Date[Year] and [2023 Population].
What will the table visual show?

Question

You have a Power Bl model that contains two tables named Population and Date.

The Population table contains two columns named Population Amount and Date Key.

DateKey contains date values that represent the first day of a year and are used to create a many-to

The Power Bl model contains two measures that have the following definitions.

Total Population = Sum ('Population'[Population Amount])

2023 Population = CALCULATE ([Total Population]'Date'[Year] = 2023)

You create a table visual that displays Date[Year] and [2023 Population].

What will the table visual show?

Igor An · Accepted Answer

a single row for the year 2023 that contains the related population value

Igor An · Answer

one row per year that contains blank values for every year except 2023

Igor An · Answer

one row per date that contains the population value for the corresponding year repeated in each row

Igor An · Answer

one row per year that contains the same value repeated for each year

List of questions