Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jan0204
Frequent Visitor

Adding a column in date table

I have tried few different ways to resolve, but cannot I understand what I am doing wrong. I have a date table named Date connected to the Invoice date in my data.  For slicer, if I use any of the columns from the date table as it is, its working fine. But if I create a new column, and use that new column for slicers, calculation in my visual is messed up. Example: I created a Qtr-year column to get a combined value using: 

CONCATENATE(Date1[Quarter],Date1[Year])
 
When I use this column as slicer, all calculations are messed up. thank you
4 REPLIES 4
v-zhengdxu-msft
Community Support
Community Support

Hi @jan0204 

 

Just as @Idrissshatila and @sayaliredij post that it should work fine.

But if your initial slicer's logic is filter by only one day, when you change it into Qty-year, the error could be caused.

You'd better re-write the measure.

Or if you change the field which you used in the measure an the begining into the new column(Qtr-year column), the Data-type are different of these two field.

It's better if you can provide more detailed description of what you did, or provide some sample data. It would be helpful to find out the solution.

 

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I was trying to create a sample file to share, but for some reason cannot recreate the same issue in sample file. Thank you for your feedback though.

Idrissshatila
Super User
Super User

Hello,

 

what do you mean by messed up, is it not showing or showing wrong , but as @sayaliredij  mentioned, it should work fine since the relationship is on the date column and this new column is just showing the data per new field.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




sayaliredij
Super User
Super User

HI @jan0204 ,

 

In general, it should work fine !! would you mind sharing sample pbix (please keep only sample data which is not business relevant )?

Thanks,

sayali





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.