Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hello everyone, I'd be very greatful if someone could help me out!
I am trying to compute new customers [newcustomercount] and have used the dax code used here for this:
https://www.sqlbi.com/articles/computing-new-customers-in-dax/
I have also created a copy of my 'Date' table called 'PreviousDate' to be able to select a single month in a visual and get 6 months filter the previous 6 months of the date table. Code for this has come from here:
https://www.youtube.com/watch?v=d8Rm7dwM6gc&t=601s
Here is a link to my pbix file in case you'd like to check it out! Thanks if you do!
https://drive.google.com/drive/folders/1j93uX4dUL6JoTJxDt3LMPWdHQD0_Nssj?usp=sharing
The Problem
I have noticed that I get a different result when,
calling a measure within calculate:
[prev6mths|callingmeasure]
.........
VAR Result =
CALCULATE(
[newcustomercount],
REMOVEFILTERS ('Date'),............
vs.
writing the measure within calculate:
[prev6mths|writtingmeasure]
................
VAR Result =
CALCULATE(
COUNTROWS (
FILTER (
CALCULATETABLE (
ADDCOLUMNS (
...............
Results:
Relationships:
My Measures:
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.