Home
Training
Consulting
Articles & Blog
Videos
Books
Tools
About

Menu
Search
0
LOGIN

Home
Training
Consulting
Articles & Blog
Videos
Books
Tools
About

Accept cookies to show this video. Cookies Policy
Allow all cookies

Table constructor { } - DAX Guide

A table constructor { } returns a table of one or more columns.
https://dax.guide/op/table-constructor/

Apr 2, 2021

LinkedIn X Facebook Email

Subscribe

Comments

You need to login in order to comment this video.

Login Or register

Please login to comment

2 Comments

Dennis Li

2 years ago

Good evening, Alberto,
I had ever attended the seminar held by Marco at NYC before years ago and keep updating all your publications over time.
Recently I got a problem with the following measure to get the insurance policy premium since I noticed that there are double counting issues.
Assuming the InforceDay as 12/31/23, given a policy with two different Endorse Expire Dates, 07/01/23 with $700 and 03/01/24 with $1100. Since the first Endorse Expire Date is < 12/31/23, the premium on 07/01/23 should be zero, and the total premium should be $1100 because only the second date 03/01/24 > 12/31/23. However, the total shows as $2200. I am not sure where the error are from.
Appreciate your help.
Dennis

Premium =
VAR InforceDay =
  MAX ( DateDimension[Date] )
RETURN
  CALCULATE (
    SUM ( Data[Premium] ),
    Data[Endorse Expire Date] > InforceDay
  )

0

StickClose

Dennis Li

2 years ago

Reply to Dennis Li

Thanks, Alberto and Marco,
I just put KeepFilters on the argument, it generated the correct result. But I really don't understand the reason. Maybe the two records are the same except the Date so KeepFilter distinguishes the two on the Date.
Have a good day.
Dennis

0

All

18:32

Understanding DAX contracts when using AI

Oct 6, 2026
23:29

The hidden complexity of a daily average in DAX

Sep 22, 2026
14:38

Writing DAX at the correct granularity

Sep 8, 2026
07:13

Matrix Totals - The Whiteboard #13

Sep 2, 2026
22:14

Testing DAX measures by using AI

Aug 25, 2026
11:40

Creating DAX functions with AI to remove duplicated code

Aug 11, 2026
17:29

Analyzing the performance impact of visual calculations

Jul 28, 2026
15:12

Dynamic formatting by hierarchy level with ISINSCOPE and ISATLEVEL

Jul 14, 2026

Newsletter

By subscribing, you agree to our Privacy Policy. This site is protected by reCAPTCHA.

276.5K subscribers

Get BI news and original content in your inbox every 2 weeks!
Newsletter archive

What is next

Mastering DAX – Oct 27
, Lugano
Mastering DAX – Nov 9
, Atlanta
Mastering DAX – Nov 24
, London
Mastering DAX – Dec 1
, Amsterdam

YouTube X LinkedIn Facebook Github RSS Feed

Marco Russo Alberto Ferrari Daniele Perilli

2004-2026 © SQLBI. All rights are reserved.
SQLBI is a trademark of SQLBI Corp.
Loader is a European legal entity.

Privacy Policy & Cookies Terms & Conditions Contact Us

You are going to send email to

Move Comment