Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, We are having a problem with the dates on power bi
We got this dataset with info from 17.01 to 30.01 (you can see total vited being 21)
When we choose a date outside this range the data gets reduced, even still being having that same range within the search
choosing from 17.01 to 31.01 instead of 17.01 to 30.01
or 01.01 to 30.01 the total visited goes down to 15
Can u help me figure out what may be the cause of this?
thanks in advanced.
Hi @MarvinConceição ,
Could you show me a data sample model and the DAX formula?
Best regards,
Lionel Chen
Hi @v-lionel-msft, I was having a trouble with may date table on the relationship with another 2 tables, and i wasn't choosing the date for today.
Still if i chose a superior date that what is on the data set, the data reduces, and I can't figure why, but its working kind of fine now, thanks!
This was my old Dax:
And This is how i is now:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |