POWERBI is adding non existent dates into my visualizations and dedicated date table
I have two tables in POWERBI and when I try creating a dedicated table or a date slicer, non existent dates are added into my data. My excel spreadsheet has data running from Feb(2024) from June(2024). I have tried turning off Time intelligence but that did not help.
Here are the table screenshots.
PowerBi – Model new and returning customers
I have ticketing transaction lists from 1999 to 2024. Each ticket purchaser has a unique ID. I want to see in Powerbi (ideally) across each year and each event how many people were new purchasers or returning purchasers.
PowerBi – Model new and returning customers
I have ticketing transaction lists from 1999 to 2024. Each ticket purchaser has a unique ID. I want to see in Powerbi (ideally) across each year and each event how many people were new purchasers or returning purchasers.
Is there a function where we can consider working days if I work only 10 hours a day between 8am – 6pm
Task