Forum Discussion

Yanou's avatar
Yanou
Icon for Helper II rankHelper II
3 years ago

How to use Switch and Summarize with date

Hello everybody,   Could you tell me what is wrong in my formula measure (always for the same visual view and data model) please ?   I would like a measure who test some date for each project and...
Need Help
v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
3 years ago

Hi, Yanou 

 

Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures. I look forward to your response.

 

Best Regards,

Community Support Team _Charlotte

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

Yanou's avatar
Yanou
Icon for Helper II rankHelper II
3 years ago

Hello V-Zhangti,

 

Thanks for your reply. Infact I did a mistake in my question. Instead of, can you please help me to reach a formula in a calculated-created column ?

 

I have a model data. I have accounts on a column and operation dates in an other. I would like to enter the lastest date in a third column. But Power BI, in each line, has to verify if the same account (in the column) hasn't a latest date. Then, enter the same latest date for each line (for the same account). Sometimes a same accounts can be in several lines.

 

Here is a example of the issue and the problem :

 

https://we.tl/t-l6GBCmut24 

 

Thanks