topic Re: Strange numbers in SELECTCOLUMNS(CALENDAR.... in DAX Commands and Tips

Strange numbers in SELECTCOLUMNS(CALENDAR....

LotteLaugesen — Thu, 28 Nov 2024 14:35:16 GMT

Hi
I'm trying to create a Normal distribution chart, but are having some problems with the SELECTCOLUMNS(CALENDAR,
These are my measures:

Normal Distribution =

VAR MinValue = FLOOR([x-3a],1)

VAR MaxValue = CEILING([x+3a],1)

RETURN SELECTCOLUMNS(CALENDAR(MinValue,MaxValue),"X",INT([Date]))

Output (53 strange rows):

When I hardcode 74 as MinVlue and 77 as MaxValue it looks correct

Can anybody tell me what I'm doing wrong?
BR

Lotte

Re: Strange numbers in SELECTCOLUMNS(CALENDAR....

lbendlin — Thu, 28 Nov 2024 15:54:10 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Strange numbers in SELECTCOLUMNS(CALENDAR....

PaulOlding — Fri, 29 Nov 2024 14:21:11 GMT

Hi LotteLaugesen

A couple of things spring to mind here:

1. Creating a table based on the value of measures isn't going to work. Tables are created during dataset refresh only, so will not be dynamic based on the measure values at report run time.

2. GENERATESERIES seems like a more appropriate function to use rather than CALENDAR.

GENERATESERIES(MinValue, MaxValue, 1)