Solved: Re: When trying to create measures the columns do ...

fernandomota02 · ‎10-31-2023

I have Excel as a data source, just one table, when I try to create aggregation measures it works, but when I try to create datediff or switch measures the columns do not appear for me to create the measure. Could you help me?

vanessafvg · ‎10-31-2023

you will need to use an aggregate function with your dates like min or max if you are creating a measure.

please share your code.

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

View solution in original post

vanessafvg · ‎10-31-2023

you will need to use an aggregate function with your dates like min or max if you are creating a measure.

please share your code.

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

audreygerred · ‎10-31-2023

Could you upload a pbix file and give some details with the measures you are trying to create?

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

Proud to be a Super User!

When trying to create measures the columns do not appear

Helpful resources

Fabric certifications survey

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly