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

9 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

9 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

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
33:19

Building bullet charts in Power BI reports

Nov 5, 2024
05:01

Improving Semantic Model Developer Productivity using DAX Optimizer

Nov 4, 2024
02:36

Safeguard Data Privacy in DAX Optimizer

Oct 28, 2024
41:01

Using weekly calendars in Power BI

Oct 23, 2024
04:24

Keep Track of Fixed Issues in DAX Optimizer

Oct 21, 2024

Newsletter

By subscribing you are agreeing to our Privacy Policy.

241.7K subscribers

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

What is next

Mastering DAX – Dec 2
, Copenhagen
Data Modeling for Power BI – Dec 10
, Amsterdam
Mastering DAX – Feb 11
, Amsterdam
Mastering DAX – Feb 18
, Phoenix
Mastering DAX – Feb 24
, Dallas

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