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 Twitter Facebook Email

Subscribe

Comments

You need to login in order to comment this video.

Login Or register

Subscribe

Notify of

Please login to comment

2 Comments

Inline Feedbacks

View all comments

Dennis Li

2 months 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 months 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

17:05

Comparing cumulative metrics for events with different start dates

Apr 23, 2024
26:39

Using EXPAND and COLLAPSE in visual calculations

Apr 9, 2024
25:49

Use scatterplots to find details in Power BI reports

Apr 3, 2024
01:39

Revolutionizing Power BI: Introducing the Ultimate Formula Language

Apr 1, 2024
19:52

Introducing EXPAND and COLLAPSE for visual calculations in Power BI

Mar 27, 2024
15:15

Vpax Obfuscator and DAX Optimizer – Unplugged #57

Mar 21, 2024
00:18

SqlBits 2024 – Day 1

Mar 20, 2024
00:35

Preparation for the training day @SqlBits 2024

Mar 20, 2024

Newsletter

By subscribing you are agreeing to our Privacy Policy.

226.9K subscribers

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

What is next

SQLBI Days – Introduction to DAX – Apr 30
, Chicago
SQLBI Days – Advanced DAX – May 1
, Chicago
SQLBI Days – First Steps in DAX Optimization – May 2
, Chicago
Mastering DAX – May 6
, Seattle
Mastering DAX – May 14
, Hamburg
Mastering DAX – May 22
, Copenhagen
SQLBI Days – Introduction to DAX – May 27
, Amsterdam

YouTube Twitter LinkedIn Facebook Github RSS Feed

Marco Russo Alberto Ferrari Daniele Perilli

2004-2024 © 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