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

10 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

10 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

25:11

Reusing formatting for Power BI reports

Dec 17, 2024
07:01

Detect and Fix Issues with Tabular Editor 3 and DAX Optimizer Integration

Dec 9, 2024
40:08

BLANK in date columns and DAX time intelligence functions

Dec 3, 2024
08:07

Real-World Use Case for DAX Optimizer: Real Estate

Dec 2, 2024
30:25

Compare DAX Optimizer vs ChatGPT vs Copilot for Power BI

Nov 25, 2024
34:26

Computing open orders with visual calculations in DAX

Nov 19, 2024
03:48

Enhance Semantic Model Development with DAX Optimizer CLI (Command Line)

Nov 18, 2024
01:50

Collaborate with your Team and Customers with DAX Optimizer

Nov 11, 2024

Newsletter

By subscribing you are agreeing to our Privacy Policy.

243.6K subscribers

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

What is next

Mastering DAX – Feb 11
, Amsterdam
Mastering DAX – Feb 18
, Phoenix
Mastering DAX – Feb 24
, Dallas
Data Modeling for Power BI – Apr 14
, 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